RE: Best way to calc transactions for the month

But that won't catch select statements.  

-- 
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: Stauffer, Robert G [mailto:rstauffer_at_decommunications.com] 
Sent: Wednesday, April 11, 2007 2:57 PM
To: Bobak, Mark; sbecker6925_at_gmail.com; oracle-l_at_freelists.org
Subject: RE: Best way to calc transactions for the month


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_at_decommunications.com


 



________________________________


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark
Sent: Wednesday, April 11, 2007 13:21
To: sbecker6925_at_gmail.com; oracle-l_at_freelists.org
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sandra Becker
Sent: Wednesday, April 11, 2007 12:24 PM
To: oracle-l_at_freelists.org
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.	

--
http://www.freelists.org/webpage/oracle-l