Manually Generating Segment Advisor Advice ========================================== Step 1 – Create a task. dbms_advisor.create_task ( advisor_name => ‘Segment Advisor’, task_id => my_task_id, task_name => test123, task_desc => my_task_desc); Step 2 – Assign an object…
Read More–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 OPEN cur FOR SELECT VALUE(x) FROM table( DBMS_SQLTUNE.SELECT_CURSOR_CACHE( ‘parsing_schema_name <> “SYS” AND…
Read MoreORA-01516: nonexistent log file, data file, or temporary file container in stand by Database: ============================================================================================= ERROR at line 1: ORA-01511: error in renaming log/data files ORA-01516: nonexistent log file, data…
Read MoreHow 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…
Read MoreAGENT DEPLOYMENT ON TARGET HOST: ================================= 1) Before creating agent image sync the EM CLI client with OMS emcli login -username=sysman -password=******** emcli sync 2)Getting agent image from OMS HOST…
Read MoreFLASHBACK 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 database…
Read MoreDBMS_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…
Read MoreDATAGUARD MONITORING ==================== Check DB role(PRIMARY/STANDBY): ================================ SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; Monitor standby background process: =================================== SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM…
Read MoreOEM CONTROL COMMANDS: ===================== Stop/start and status oms in cloud control =============================== cd $ORACLE_HOME/bin emctl stop oms emctl start oms emctl status oms stop/start agent in oem cloud control =====================================…
Read MoreViewing 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.…
Read More