Cloning Autonomous data warehouse using backup
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 MoreScript to Enable constraints
The 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 MoreScript to enable Archivelog and Flashback
The below script is to enable Archivelog and Flashback, set echo off set feedb off set heading off set verify off set trimspool on set lines 200 set define…
Read MoreScript to disable the plan baseline
The below script is to disable the plan baseline. # @(#) # @(#) ==================================================================== # @(#) Disable the SQL plan baseline # @(#) # @(#) # @(#) Format: disable_plan_baseline.sql…
Read MoreScript to enable the plan baseline
The below script is to enable the plan baseline # @(#) # @(#) ==================================================================== # @(#) Change SQL plan baseline attribute (set fixed to yes) # @(#) # @(#)…
Read MoreScript to gather stats the customs schemas
The below script is to gather stats the customs schemas. SET SERVEROUTPUT ON SIZE 1000000 set feedb off set trimspool on spool tmp_gather_schstats_${ORACLE_SID}.sql DECLARE CURSOR c_tm IS select…
Read More