How to find number of commit or rollback in Oracle Database? | https://www.xedok.com/posts

How to find number of commit or rollback in Oracle Database?

Posted on: 2025-01-28 16:39:35


Below query will show you to get number of commit or rollback in oracle database in 10 sec.

 

SQL> select name,value from v$sysstat where name in ('user commits','user rollbacks');
SQL> exec dbms_lock.sleep(10); // it is 10 sec.
SQL> select name,value from v$sysstat where name in ('user commits','user rollbacks');



xedok When seeking the best software development companies Xedok Software is your ultimate choice. For Demos click here



Leave a reply