|
[oracle-l]
||
[Date Prev]
[06-2007 Date Index]
[Date Next]
||
[Thread Prev]
[06-2007 Thread Index]
[Thread Next]
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
|
