+5 DGMGRL> EDIT DATABASE nsndb SET PROPERTY ‘LogXptMode’=’SYNC’; Property “LogXptMode” updated DGMGRL> EDIT DATABASE nsnstd SET PROPERTY ‘LogXptMode’=’SYNC’; Error: ORA-16789: missing standby redo logs
Posts Tagged ‘Uncategorized’
Query to get uncommitted statements


+5 Query to get uncommitted statements(INSERT, UPDATE or DELETE statements) in the current session: SQL> SELECT COUNT(*) FROM v$transaction t, v$session s, v$mystat m WHERE t.ses_addr = s.saddr AND s.sid = m.sid AND ROWNUM = 1; COUNT(*) ———- 0 IF: count>0 SQL> SELECT COUNT(*) FROM v$transaction t, v$session s, v$mystat m WHERE t.ses_addr = s.saddr […]