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

Posted on: 2022-04-14 11:46:06


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