Manually Generating Segment Advisor Advice ========================================== Step 1 – Create a task. dbms_advisor.create_task ( advisor_name => ‘Segment Advisor’, [...]

–Create the tuning set EXEC DBMS_SQLTUNE.CREATE_SQLSET(‘HIGH_DISK_READS’); –Populate the tuning set from the cursor cache DECLARE cur DBMS_SQLTUNE.SQLSET_CURSOR; BEGIN [...]

ORA-01516: nonexistent log file, data file, or temporary file container in stand by Database: ============================================================================================= ERROR [...]

How To Resolve Agent Stuck Issue: ================================= Workout 1. emctl stop agent 2. ps -ef | grep emagent kill all the process 3. emctl start agent Oracle Enterprise Manager 11g [...]

AGENT DEPLOYMENT ON TARGET HOST: ================================= 1) Before creating agent image sync the EM CLI client with OMS emcli login -username=sysman -password=******** emcli sync [...]

FLASHBACK RESTORE POINT: ======================= Restore point plays important role in restore and recovery scenario as it allows to store the state of the database to a certain point. The [...]

DBMS_SCHEDULER in Oracle Database Scheduler in the Oracle Database is done by DBMS_SCHEDULER package. This package can be used to create different types of jobs :- 1. Jobs having Program and [...]

DATAGUARD MONITORING ==================== Check DB role(PRIMARY/STANDBY): ================================ SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, [...]

OEM CONTROL COMMANDS: ===================== Stop/start and status oms in cloud control =============================== cd $ORACLE_HOME/bin emctl stop oms emctl start oms emctl status oms [...]

Viewing an Alert Log from ADRCI ================================ You want to view an alert log by using ADRCI commands. To view an alert log with ADRCI, follow these steps: Invoke ADRCI. $ adrci [...]