Top 5 SQL statements sorted by Elapsed time

tkprof isi_ora_2872.trc awlrs_trace.out sys=no print=5 sort=(prsela,exeela,fchela)

To sort by CPU time use sort=(prscpu,execpu,fchela)

emctl status agent shows :

Last successful upload: (none)

Last attempted upload : (none)

Number of Targets : (none)

Or

OMS reports

Status  Availability Evaluation Error

Fix

• emctl config agent addinternaltargets
• emctl config agent listtargets
• emctl stop agent
• emctl clearstate agent
• emctl secure agent
• emctl start agent

Metalink Note DOC ID 2315692.1

$TFA_HOME/bin/tfactl diagcollect -srdc dbperf

DDLSUBST ‘PRODUSA_DATA’ WITH ‘USPRD_DATA’ INCLUDE ALL
DDLSUBST ‘PRODUSA_DATA_ENC’ WITH ‘USPRD_DATA’ INCLUDE ALL
DDLSUBST ‘PRODUSA_IDX’ WITH ‘USPRD_IDX’ INCLUDE ALL
DDLSUBST ‘PRODUSA_LOB’ WITH ‘USPRD_DATA’ INCLUDE ALL

Easily view lag information for all members.

DGMGRL> show configuration lag

Configuration – dgdcdb_devl

Protection Mode: MaxPerformance
Members:
dgdcdb   – Primary database
dgdcdb_s – Physical standby database
Transport Lag:      0 seconds (computed 0 seconds ago)
Apply Lag:          0 seconds (computed 0 seconds ago)

Fast-Start Failover:  Disabled

Configuration Status:
SUCCESS   (status updated 19 seconds ago)

alter system set “_optimizer_nlj_hj_adaptive_join”= FALSE scope=both sid=’*’;

alter system set “_optimizer_strans_adaptive_pruning” = FALSE scope=both sid=’*’;

alter system set “_px_adaptive_dist_method” = OFF scope=both sid=’*’;

alter system set “_sql_plan_directive_mgmt_control” = 0 scope=both sid=’*’;

alter system set “_optimizer_dsdir_usage_control” = 0 scope=both sid=’*’;

alter system set “_optimizer_use_feedback” = FALSE scope=both sid=’*’;

alter system set “_optimizer_gather_feedback” = FALSE scope=both sid=’*’;

alter system set “_optimizer_performance_feedback” = OFF scope=both sid=’*’;

alter system set optimizer_adaptive_plans=FALSE scope=both;

alter system set “_allow_insert_with_update_check”=TRUE;

./runInstaller  -waitforcompletion -silent                        \
-responseFile ${ORACLE_HOME}/install/response/db_install.rsp               \
oracle.install.option=INSTALL_DB_SWONLY                                    \
ORACLE_HOSTNAME=${ORACLE_HOSTNAME}                                         \
UNIX_GROUP_NAME=dba                                                   \
INVENTORY_LOCATION=${ORA_INVENTORY}                                        \
SELECTED_LANGUAGES=en,en_GB                                                \
ORACLE_HOME=${ORACLE_HOME}                                                 \
ORACLE_BASE=${ORACLE_BASE}                                                 \
oracle.install.db.InstallEdition=EE                                        \
oracle.install.db.OSDBA_GROUP=dba                                          \
oracle.install.db.OSBACKUPDBA_GROUP=dba                                    \
oracle.install.db.OSDGDBA_GROUP=dba                                        \
oracle.install.db.OSKMDBA_GROUP=dba                                        \
oracle.install.db.OSRACDBA_GROUP=dba                                       \
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false                                 \
DECLINE_SECURITY_UPDATES=true

DGMGRL> start observer in background file is /home/oracle/backup_observer_1.dat logfile is /home/oracle/backup_observer_1.log connect identifier is oradb1;