My Oracle DBA Notes
Labels
Oracle E-Business Suite
Database
Middleware
Others
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment