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 MoreIssue: 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 MoreClick here to Download
Read MoreThe 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 MoreThe below script is to get metadata for all dblinks # @(#) ==================================================================== # @(#) Reverse engineering all database links # @(#) # @(#) # @(#) Format: reverse_all_dblinks.sql #…
Read MoreThe 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 MoreThe below script is to Enable 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