Re: number of transactions in a day
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: afatkulin@xxxxxxxxx
- Date: Fri, 1 Jun 2007 13:30:03 -0700
On 6/1/07, Alexander Fatkulin <afatkulin@xxxxxxxxx> wrote:
You can use something like statspack does:
user commits + user rollbacks
v$sysstat
I like this one:
with commits as (
select value commits
from v$sysstat
where name = 'user commits'
),
gets as (
select sum(value) gets
from v$sysstat
where name like '%gets%'
)
select g.gets / c.commits transactions
from gets g, commits c
/
Or pick any alternative that makes the mgrs happy.
The database cannot tell them what they want to know.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
