RE: Best way to calc transactions for the month

From: Richard J. Goulet <rgoulet_at_kanbay.com>
Date: Wed, 11 Apr 2007 12:58:32 -0400
Message-ID: <C3EE2ADD31ACF64DAB1B236044A1968D68DEF0@miaexc01.kanbay.com>

Sandy,  

    The only way that I can think of to get all of this at one time would be to enable Oracle auditing and browse the AUD$ table. Oh yes, you'd have to audit select, insert, update, and delete whenever successful.  

........................................................................


............................................................. 

Kanbay <http://www.kanbay.com/>
Richard J. Goulet, Senior Oracle DBA
45 Bartlett ST | Marlborough, MA 01752 USA Tel: 508.573.1978 | Fax: 508.229.2019 | Cell: 508.742.5795

rgoulet_at_kanbay.com <mailto:rgoulet_at_kanbay.com> 
........................................................................


............................................................. 



 

________________________________

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

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

Received on Wed Apr 11 2007 - 11:58:32 CDT