How to Format Corrupted Block Not Part of Any Segment
Step 1 – Identify corrupt datafile The corruption may be reported at the application level, such as DBV and RMAN, or the alert.log. Step 2 Run DBV/Rman validate on affected…
Read MoreTips to import the export and import datapump performance
1) Use parallel 2)While mentioning the dump file, use _%U.dmp (generates multiple dumps), which will be faster. 3)Increase the stream pool size alter system set streams_pool_size=2G; alter system set “_disable_streams_pool_auto_tuning”=TRUE;…
Read MoreAn Invalid redirect has been blocked error
Issue: As we all know, APEX page can be integrated into EBS as a function. After integrating Apex pages in EBS 12.2 when you access apex page from EBS, you…
Read MorePerforming Expdp/Impdp in Autonomous datawarehouse using SQLDEVELOPER
Click here to Download
Read MoreScript to check Long running 12c forms in Forms Application server
The below script is to check Long running 12c forms in Forms Application server #!/bin/bash ############################################################################### # File Name : long_runn_forms.sh # Author : Vimal Raju # Date :…
Read MoreScript to get metadata for all dblinks
The below script is to get metadata for all dblinks # @(#) ==================================================================== # @(#) Reverse engineering all database links # @(#) # @(#) # @(#) Format: reverse_all_dblinks.sql #…
Read MoreScript to Disable constraints
The below script is to Disable constraints, SET PAGES 0 SET TRIMSPOOL ON SET LINES 200 set echo off set feedb off set trimspool on set verify off col…
Read More