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…
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 MoreSending Email From Oracle using Amazon Simple Email Service (SES)
Use the below Link to create the Cerfiticate using Amazon SMTP address. https://whatsmychaincert.com/?email-smtp.us-east-1.amazonaws.com Creating Oracle Wallet : mkdir -p /u01/app/oracle/wallet/TEST orapki wallet create -wallet /u01/app/oracle/wallet/TEST orapki wallet add -wallet /u01/app/oracle/wallet/TEST…
Read MoreORA-00392: log 4 of thread 1 is being cleared, operation not allowed
Got the below error during cloning. To fix this issue, need to “clear unarchived logfile group” Solution : SQL> alter database open resetlogs; alter database open resetlogs * ERROR…
Read More