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