Re: Tracing Commit by user

On Sat, 30 Sep 2006 04:28:44 -0700, peter wrote:

> Please tell it how to trace commit by any user.
> Means if any user commiting data again and again then how can we trace
> it ( How can u come to know who is doing this again and again ).

select s.sid,s.value
from v$sesstat s,v$statname n
where s.statistic#=n.statistic# and

      n.name='user commits'
order by s.value
/

-- 
http://www.mladen-gogala.com