Re: number of transactions in a day

On 6/1/07, Alexander Fatkulin <afatkulin_at_gmail.com> 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

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