How to find number of commit or rollback in Oracle Database

Posted on: 2023-02-01 17:10:25


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 I trust you appreciate perusing this blog entry. Assuming you need my group to simply do your promoting for you. click here



Leave a reply