Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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