Loading....

Knowledge Base New

  1. Oracle Enterprise Manager Cloud Control 13.4 Patching
  2. 19c FSFO Observer – some findings
  3. Data Guard Observer 19c – Observe Only Mode new feature
  4. FSFO with multiple standby database targets
  5. Cloning an Oracle 19c Oracle Home
  6. 19c Container Database Data Guard Configuration
  7. Oracle 12c to 19c Data Guard Upgrade with 19c Container Database
  8. Upgrade Oracle 12c non-CDB to Oracle 19c and plugin to CDB
  9. Unified Auditing – Getting Started
  10. How to install and configure Oracle 12c Release 2 RAC environment on VirtualBox Part 3

Notes

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)

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

 

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

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

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)

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;

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

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;

Knowledge Base Top Categories

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?