Knowledge is Power share IT

Time 2020-11-05 13:08:15

Web Name: Knowledge is Power share IT

WebSite: http://gavinsoorma.com

ID:105821

Keywords:

is,Knowledge,Power,

Description:

D:\oracle\middleware\bin emcli list_plugins_on_agent -agent_names=CPVDC1ORA1.localdomain:3872The 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.0Oracle Database oracle.sysman.db 13.4.1.0.0 Top 5 SQL statements sorted by Elapsed timetkprof 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) DDLSUBST PRODUSA_DATA WITH USPRD_DATA INCLUDE ALLDDLSUBST PRODUSA_DATA_ENC WITH USPRD_DATA INCLUDE ALLDDLSUBST PRODUSA_IDX WITH USPRD_IDX INCLUDE ALLDDLSUBST PRODUSA_LOB WITH USPRD_DATA INCLUDE ALL Easily view lag information for all members.DGMGRL show configuration lagConfiguration dgdcdb_devlProtection Mode: MaxPerformanceMembers:dgdcdb   Primary databasedgdcdb_s Physical standby databaseTransport Lag:      0 seconds (computed 0 seconds ago)Apply Lag:          0 seconds (computed 0 seconds ago)Fast-Start Failover:  DisabledConfiguration 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;

TAGS:is Knowledge Power 

<<< Thank you for your visit >>>

Hot Websites