Thursday, September 15, 2011

How to get number of user commits since instance started.

select to_char(sysdate,'DD-MM-YYYY HH:MI:SS'), sum(value) sum from v$sysstat where name like 'user commits' or name like 'user rollbacks';
Instance start time:
SELECT * FROM V$INSTANCE

No comments:

Post a Comment