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
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
Messages: 24969
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: 63935
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');

1 row selected.

Previous Topic: Sub Query / Lookup
Next Topic: Problem with LIKE
Goto Forum:

Current Time: Thu Oct 27 12:12:05 CDT 2016

Total time taken to generate the page: 0.06756 seconds