How to Backup ORACLE_HOME binaries and Oracle INVENTORY ORACLE_HOME and INVENTORY need to backup before Database / OS level patching Table of Contents ______________________________________ [...]

Step 1: Identify OCR physical backup using the following command [root@rac1 ~]# ocrconfig -showbackup rac2 2020/04/03 16:57:56 /u01/app/12.1.0/grid/cdata/rac-scan/backup00.ocr 0 rac1 2020/04/01 [...]

Transferring statistics between database In general, development DB usually will have only portion of the data when we compared to Production database. [...]

Histogram Stats in Columns [...]

How to create SQL profiles using the SQLT utility. Oracle has a utility called SQLT to create profiles. [...]

    Find the memory on the host: [gg60@ut03 :+ASM] /home/dba/gg60 $ free -m total       used       free     shared    buffers     cached [...]

Snapshot standby is a feature in Oracle 11g that allows doing a read-write operation on the standby database. i. e we can convert the physical standby database to snapshot standby. On that, we [...]

SQL PROFILE IN ORACLE SQL profile is a collection of additional statistical information stored in the data dictionary that helps the optimizer to generate the best plan for the query. SQL profile [...]

Creating sqlplan Baselines Create sql tuning set ————————- begin DBMS_SQLTUNE.CREATE_SQLSET(SQLSET_NAME => ‘&&sql_id’, [...]

Current Status Of Redo Logs Primary Side SQL> select group#,sum(bytes/1024/1024)”Size in MB” from v$log group by group#; GROUP# Size in MB ——- ———- 1 [...]