RE: Best way to calc transactions for the month
- From: "Stauffer, Robert G" <rstauffer@xxxxxxxxxxxxxxxxxxxx>
- To: <Mark.Bobak@xxxxxxxxxxxxxxx>, <sbecker6925@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 11 Apr 2007 14:57:13 -0400
Sandy,
I'm not sure how practical/painful it would be in your case, but
analyzing log miner output might be an option.
Bob Stauffer
DBA
D&E Communications
Ephrata, PA, USA
717-738-8737
rstauffer@xxxxxxxxxxxxxxxxxxxx
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark
Sent: Wednesday, April 11, 2007 13:21
To: sbecker6925@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Best way to calc transactions for the month
Well, if you look at Statspack snapshots, that will give you transaction
rate, but it won't include selects. If I recall correctly, it looks at
the user rollbacks and user commits statistics. In fact, it will count
transactions, which could be made up of many DML statements.
Hmm...I can't think of any good way to do this, short of turning on
trace or auditing, and summarizing data from there.
Any chance you can talk him out of asking for what he's asking for? ;-)
It's almost certainly not at all meaningful or useful, but convincing
him of that may be a political and diplomatic challenge...;-)
-Mark
--
Mark J. Bobak
Senior Oracle Architect
ProQuest/CSA
"There are 10 types of people in the world: Those who understand
binary, and those who don't."
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sandra Becker
Sent: Wednesday, April 11, 2007 12:24 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Best way to calc transactions for the month
The president of the company would like to know how many transactions
per month are running through the database. He wants to include all
selects, inserts, updates, and deletes. What would be the best way to
gather this information. Is there a way I can easily break it down by
each type of transaction?
Oracle 9.2.0.8, RHEL 4.0
Sandy
**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use
of the individual or entity to which they are addressed and may contain
information that is privileged, proprietary and confidential. If you are not
the intended recipient, you may not use, copy or disclose to anyone the message
or any information contained in the message. If you have received this
communication in error, please notify the sender and delete this e-mail
message. The contents do not represent the opinion of D&E except to the extent
that it relates to their official business.
Other related posts:
