Hello, how to add custom metric to EM with «bad» sql and how-to diagnose results: usefull links first: Creating an Information Publisher Report based on a Custom Metric Extension whats_changed.sql based on this material add custom metric with query from query with performance degradation running more than 5 sec after all Enjoy the message like … Читать далее
find query with performance degradation running more than 5 sec : original by Kerry Osborne
while trying to commit distibuted transaction faced with «free global transaction table entry» solution foud at mos 549307.1 define local_tran_id: use mos note to force commit transaction: transaction state changed to forced commit ( or commit forced =) ), after that purge transcation entry
*copy passwd file from primary scp $ORACLE_HOME/dbs/passwd$ORACLE_SID{instance_number} cp [pwd file from primary] orapw$ORACLE_SID *create static listener create audit directory: create asm directory: *startup dummy instance: *connect auxiliary instance +connect target instance
ORA-15025, KFSG-00312, ORA-15081 Database Creation on 11.2 Grid Infrastructure with Role Separation ( ORA-15025, KFSG-00312, ORA-15081 ) (Doc ID 1084186.1) su — grid $ORACLE_HOME/bin/setasmgidwrap o=/oracle/app/base/db/12.1.0.2/bin/oracle