Re: Best way to calc transactions for the month
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: sbecker6925@xxxxxxxxx
- Date: Wed, 11 Apr 2007 11:11:03 -0700
On 4/11/07, Sandra Becker <sbecker6925@xxxxxxxxx> wrote:
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 knows about commits:
SQL>l
1 select class,name, value
2 from v$sysstat
3* where name = 'user commits'
SQL>/
CLASS NAME VALUE
----- ---------------------------------------- -----------------
1 user commits 17,579,778
1 row selected.
A transaction from a business perspective is not
necessarily the same thing as a transaction from
a database perspective.
With SAP for instance the Basis admin can answer
that question from SAP statistics. Oracle has no
idea how many SAP transactions have been run.
Ask the President what it is he actually wants to know.
It may have nothing to do with transactions.
Also, a SELECT is not usually considered a transaction.
If you *really* want to count INSERT,SELECT,UPDATE and DELETE,
then you would need to audit all tables and views in the database.
Or use some 3rd party tool to do this for you.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
