RE: Best way to calc transactions for the month
- From: "Richard J. Goulet" <rgoulet@xxxxxxxxxx>
- To: <sbecker6925@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 11 Apr 2007 12:58:32 -0400
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@xxxxxxxxxx <mailto:rgoulet@xxxxxxxxxx>
........................................................................
.............................................................
________________________________
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
Other related posts:
