My Home

[bkb_search placeholder=”Search the KB ….” cont_ext_class=”bkb-sbox-layout-1 rounded-box”][vc_bkb_posts kb_type_title=”Knowledge Base New” kb_type_title_status=”1″ paginate=”0″ posts_per_page=”10″]

Notes

[usa_container toggle=”true” ctrl_btn=”true” search=”true” theme=”custom” title_bg=”#cecece” title_text_color=”#000000″ nav_box_bg=”#e2e2e2″ title_active_text_color=”#f0f0f0″ nav_active_box_bg=”#d6d6d6″ title_tag=”h6″ tt_font_size=”12″ highlight_bg=”#ff0000″ highlight_color=”#ffffff” content_bg=”#fbfbfb” content_link_color=”#2c2c2c” pagination=”true” limit=”10″][usa_item acc_title=”Single TFA command to collect performance related diagnostic data”]$TFA_HOME/bin/tfactl diagcollect -srdc dbperf[/usa_item][usa_item acc_title=”List plugins deployed on OEM management agent”]D:\oracle\middleware\bin>emcli list_plugins_on_agent -agent_names=CPVDC1ORA1.localdomain:3872

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]

Knowledge Base Top Categories

[bkb_category categories=”goldengate,oracle-cloud,performance-tuning,multitenancy,database-administration,data-guard,scripts,real-application-clusters,cloud-control” box_view=”0″ cols=”3″ bkb_desc=”0″ limit=”5″ orderby=”date” posts_count=”1″ count_info=”1″]