Re: High "transaction rollbacks" value in v$sysstat
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- To: Brandon.Allen@xxxxxxxxxxx
- Date: Thu, 08 Sep 2005 23:46:46 +0000
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
