Backup oracle home and inventory

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

Recovering OCR using physical backup

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 [...]

Huges_Pages Setup for Host

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

SQL PROFILE IN ORACLE

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

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

Start typing and press Enter to search