Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: number of transactions in a day
Why divide by gets??? You'll get "some gets" per transaction...
go for dbms_random then :)
P.S. you can do everything in one shot:
select sum(case when name like '%gets%' then value else 0 end)/ sum(case when name like 'user_commit%' then value else 0 end) "something" from v$sysstat where name like '%gets%' or name like 'user_commit%';
On 6/1/07, Jared Still <jkstill_at_gmail.com> wrote:
> On 6/1/07, Alexander Fatkulin <afatkulin_at_gmail.com> wrote:
> 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
>
-- Alexander Fatkulin -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 01 2007 - 15:36:57 CDT
![]() |
![]() |