Notes
The Agent URL is https://CPVDC1ORA1.localdomain:3872/emd/main/ –
Plug-in Name Plugin-id Version [revision]
Oracle Home oracle.sysman.oh 13.4.0.0.0
Oracle Database oracle.sysman.db 13.4.1.0.0[/usa_item][usa_item acc_title=”TKPROF Top 5 SQL statements sorted by Elapsed time”]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)[/usa_item][usa_item acc_title=”13c Agent Not Uploading To OMS”]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
[/usa_item][usa_item acc_title=”How to Collect Standard Information for a Database Performance Problem Using TFA Collector”]Metalink Note DOC ID 2315692.1
$TFA_HOME/bin/tfactl diagcollect -srdc dbperf[/usa_item][usa_item acc_title=”GoldenGate DDL handle Tablespace name differences”]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[/usa_item][usa_item acc_title=”Data Guard Broker 19c SHOW CONFIGURATION LAG”]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)[/usa_item][usa_item acc_title=”Cloud Control 13.4 Repository Database Parameters”]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;[/usa_item][usa_item acc_title=”Oracle 19c Silent Install”]./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[/usa_item][usa_item acc_title=”Start Observer in background”]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;[/usa_item][/usa_container]