Re: 'user commits' statistic for one user

Hi Sybrand
I was only using 'SYS' as an example.
However after all my troubles.. I now realise that running UTLBSTAT.sql and UTLESTAT.sql gives me all the figures I need. However one really needs to be an expert in interpreting these results.

I think I need to look at the EXECUTE COUNT counter to give me the total number of SQL statements sent to Oracle by users. Is there a good source say a Book or Web site that explains these counters?

In particular I'd like to know which are the top 10 counters to watch!!

Jack

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:tg85fcimhjbp1b_at_beta-news.demon.nl...
>
> What are you exactly up to? Do you think SYS runs all transactions? That's
> not true.
> Also I don't think recursive sql (sql on the datadictionary) is tracked,
 and
> if you are running your own code under the user SYS, that's just plain
> stupid.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
>
> "Jack" <No_at_Mail.Please> wrote in message
> news:mbNM6.34659$662.171273_at_news1-hme0...
> > select v$sesstat.value
> > from v$sesstat ,v$session
> > where v$sesstat.sid= v$session.sid
> > and v$session.username='SYS'
> > and v$sesstat.STATISTIC# =9
> >
> > Rem 9 = session logical reads or 4 = user commits
> >
> > Will this give me all the 'user commits' (transactions) for user SYS?
> >
> > Thanks
> >
> > "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> > news:tg5g9r7qc2vk87_at_beta-news.demon.nl...
> > >
> > > "Jack" <No_at_Mail.Please> wrote in message
> > > news:jkyM6.31453$662.165155_at_news1-hme0...
> > > > Hi
> > > > Is there a way of finding the number of 'user commits' (or number of
> > > > transactions) for one user only?
> > > >
> > > > Thanks
> > > >
> > > >
> > >
> > > If you need the sid of the session
> > > you can use v$sesstat where sid = <yoursid>
> > >
> > > You can know the sid by
> > > running
> > > select sid
> > > from v$session
> > > where audsid = userenv('sessionid')
> > > /
> > >
> > > in your program.
> > >
> > > Hth,
> > >
> > > Sybrand Bakker, Oracle DBA
> > >
> > >
> > >
> >
> >
>
>
Received on Fri May 18 2001 - 03:50:05 CDT