Monday, October 6, 2008

Number of commits executed by a session.

This SQL displays the number of commits executed by a session.
select value from v$sesstat
where sid in (select sid
from v$session where username = '&user')
and statistic# in (select statistic#
from v$statname where name like '%user%commit%')
/

No comments:

search engine

Custom Search