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
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: 25050
Registered: January 2009
Location: SoCal
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: 64153
Registered: March 2007
Location: Nanterre, France, http://...
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: 25050
Registered: January 2009
Location: SoCal
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: Question on how Merge works with a comibination of Update and Delete
Next Topic: To store just Time information in Oracle column
Goto Forum:
  


Current Time: Sun Dec 11 08:08:13 CST 2016

Total time taken to generate the page: 0.08098 seconds