Re: High "transaction rollbacks" value in v$sysstat

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Thu, 08 Sep 2005 23:46:46 +0000
Message-Id: <1126223206l.31981l.0l@medo.noip.com>

On 09/08/2005 07:19:00 PM, Allen, Brandon wrote:
> Not sure, I don't have good visibility into the application (Tririga Facility Center 8i). But if the application is rolling back, shouldn't I see 'user rollbacks' being incremented at least as much as 'transaction rollbacks'?

I have a very simple solution: look into DBA_AUDIT_TRAIL. Turn on auditing. People often forget to do that, but that is the only way to know what has someone executed during the last week or some other extended period of time.

-- 
Mladen Gogala
http://www.mgogala.com


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 08 2005 - 18:48:49 CDT