Home » SQL & PL/SQL » SQL & PL/SQL » solve the query
solve the query [message #278413] Sat, 03 November 2007 23:24 Go to next message
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 #278414 is a reply to message #278413] Sat, 03 November 2007 23:27 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
EXACTLY what qualifies as a transaction?
In Other Words (IOW), how will you verify the answer returned is correct?
Re: solve the query [message #278419 is a reply to message #278413] Sun, 04 November 2007 01:41 Go to previous message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Sub Query / Lookup
Next Topic: Problem with LIKE
Goto Forum:
  


Current Time: Tue Dec 06 10:13:33 CST 2016

Total time taken to generate the page: 0.23966 seconds