Re: Audit commits.

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Mon, 28 Jan 2002 16:47:39 +0000
Message-ID: <3C5580AB.B6DB77B@exesolutions.com>

You do not need to catch who is performing commits. You need to look at the SQL being executed. The problem you describe should never happen in Oracle. Monitor various V$ views like v$sqlarea and v_$open_cursor that contain the SQL being executed.

In fact, thinking about your statement, I'm not sure if I could even figure out how to lock users with a commit. Perhaps Tom Kyte can but it is well beyond my pay grade.

Daniel Morgan

vdolt wrote:

> I am running 8.1.6 EE on NT. I need to find a way
> to catch "COMMIT" statements. Is there a way
> to put AUDIT on a commit?
> We have "transactional" database, where
> data just passes through. When someone commits it causes
> all other users to get locked, so I need to catch
> who is doing that.
> Thanks.
Received on Mon Jan 28 2002 - 10:47:39 CST