Re: 'user commits' statistic for one user

"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 Wed May 16 2001 - 13:06:52 CDT