| solve the query [message #278413] |
Sat, 03 November 2007 23:24  |
sunilcse1
Messages: 23
Registered: June 2007
Location: Bangalore
|
Junior Member |
|
|
Hello all
I have a query that how could I know how many transaction that have been taken place in a single day.
|
|
|
|
|
|
| Re: solve the query [message #278419 is a reply to message #278413] |
Sun, 04 November 2007 01:41  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Strictly, you can't but you can have the number of transactions since the beginning of the instance with:
SQL> select sum(value) from v$sysstat where name in ('user commits','user rollbacks');
SUM(VALUE)
----------
254
1 row selected.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
