Re: Tracing Commit by user

From: Mladen Gogala <mgogala.spam-me-not_at_verizon.net>
Date: Sat, 30 Sep 2006 19:51:35 GMT
Message-Id: <pan.2006.09.30.19.51.18.249933@verizon.net>

On Sat, 30 Sep 2006 19:41:38 +0000, Mladen Gogala wrote:

> 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
> /

The SQL statement above can also be idiotized to the first idiotic form like this:

select s.sid,s.value
from v$sesstat s join v$statname n on (s.statistic#=n.statistic#) where n.name='user commits'
order by s.value

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

Received on Sat Sep 30 2006 - 14:51:35 CDT