Home » SQL & PL/SQL » SQL & PL/SQL » Transaction Count on a Database for a given day
Transaction Count on a Database for a given day [message #328024] Wed, 18 June 2008 11:24 Go to next message
dksampat
Messages: 12
Registered: December 2006
Karma: 0
Junior Member
I need to find the count of transactions (both SELECT's and DML's ) that happen on my Database for a given day. It should include SELECT's and DML's too. Please advice
Re: Transaction Count on a Database for a given day [message #328026 is a reply to message #328024] Wed, 18 June 2008 11:27 Go to previous messageGo to next message
BlackSwan
Messages: 25578
Registered: January 2009
Location: SoCal
Karma: 0
Senior Member
AUDIT all objects will produce the numbers you desire but at the price of reduced performance.
Trade-offs!

[Updated on: Wed, 18 June 2008 11:28] by Moderator

Report message to a moderator

Re: Transaction Count on a Database for a given day [message #328027 is a reply to message #328024] Wed, 18 June 2008 11:30 Go to previous messageGo to next message
Michel Cadot
Messages: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
Senior Member
Account Moderator
Transactions and statements (DML, query) are 2 different things.
Do you want transactions or statements count?
For transactions there are internal statistics, for statement you have to use audit but read what Ana posted.

Regards
Michel
Re: Transaction Count on a Database for a given day [message #328032 is a reply to message #328024] Wed, 18 June 2008 12:03 Go to previous message
BlackSwan
Messages: 25578
Registered: January 2009
Location: SoCal
Karma: 0
Senior Member
I suspect that these number were requested by some Pointy Haired Boss who could not even spell S-Q-L.

Since not all SQL are created equal (some statements require MUCH more work by the database engine), the desired number are really, really meaningless.

These number are not reliable to make any decisions or conclusions based on them.

If you said the system did X SELECTS & Y DML, what have you really learned?

Garbage In, Garbage Out (GIGO)!
Previous Topic: How to delete rows from parent table without scanning child tables?
Next Topic: Better way of writing the code
Goto Forum:
  


Current Time: Tue Aug 22 13:51:53 CDT 2017

Total time taken to generate the page: 0.13937 seconds