Re: Tracing Commit by user

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 ).

The number of commits is is v$sysstat (system-wide) and v$sesstat and can be retrieved using statspack.

Excessive committing is usually a result of using an application with any autocommit setting on. This means it commits individual inserts and updates.
The number of records affected by a commit can be retrieved using the logminer package.

This is an application issue and not an end-user issue. The end-user can't help it, he has been provided with a crappy piece of software.

-- 
Sybrand Bakker
Senior Oracle DBA