Script 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 ...
Database
Insights and Experiences from Doyensys’ Database Administrators.
Script to get metadata for all dblinks
The below script is to get metadata for all dblinks # @(#) ==================================================================== # @(#) Reverse ...
Script 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 ...
Script 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 ...
Script 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 ...
Script 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 : ...
Script to get metadata for all dblinks
The below script is to get metadata for all dblinks # @(#) ==================================================================== # @(#) Reverse engineering all database links # @(#) # @(#) ...
Script 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 stmt format a80 — ALTER TABLE ...
Script 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 stmt format a80 — ALTER TABLE ...
Script 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 on SET SERVEROUTPUT ON SIZE ...
Script to disable the plan baseline
The below script is to disable the plan baseline. # @(#) # @(#) ==================================================================== # @(#) Disable the SQL plan baseline # @(#) # @(#) # ...
Script to enable the plan baseline
The below script is to enable the plan baseline # @(#) # @(#) ==================================================================== # @(#) Change SQL plan baseline attribute (set fixed to ...
Script 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 ...
Script to identify ASM diskgroup space
set serveroutput on declare v_diskgroup_name varchar2(50); v_total_space number(12); v_free_space number(12); v_pct_free number(6,3); begin for diskgroup_rec in (select name from v$asm_diskgroup) ...
Materialized view refresh
MVIEW LOG =========== col log_owner for a30 col master for a40 col log_table for a40 col last_purge_date for a30 col last_purge_status for 9999999 select ...