+5 Top Ten most CPU TIME Queries SELECT sql_text,ROUND (CPU_TIME/1000000) "CPU_TIME in Seconds" FROM (SELECT sql_text, CPU_TIME,rank() over ( order by CPU_TIME DESC) rank_desc FROM v$sql) WHERE rank_desc>10;
Archive for the ‘Uncategorized’ Category
Posted in 
Tags: 
ORA-16789: missing standby redo logs
April 19th, 2012 
rishi +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
Query to get uncommitted statements in the current session
July 23rd, 2011 rishi +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 […]
Query to get uncommitted statements
July 22nd, 2011 rishi +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 […]
