Re: 'user commits' statistic for one user

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 Thu May 17 2001 - 13:20:29 CDT