Query to get uncommitted statements in the current session

July 23rd, 2011

rishi

0

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
AND s.sid = m.sid
AND ROWNUM = 1;

COUNT(*)
———-

1

i.e. You have uncommited statement…do either commit or rollback as appropriate.

0

You can skip to the end and leave a response. Pinging is currently not allowed.

Dwonload OracleDbaHub Android App