Re: Tracking when users rollback

rollbacks are tracked in v$sysstat and v$sesstat. This means utlbstat/utlestat will report the number of rollbacks during a certain period of time.
The rollback statement itself *does* appear in trace files. I do not know from the top of my head whether you can audit it.

Hth,

Sybrand Bakker, Oracle DBA

<kal121_at_my-deja.com> wrote in message news:8l9vlj$kmk$1_at_nnrp1.deja.com...
> Hi,
>
> Is there a way to track when a certain user has issued a "rollback"
> statement? Can this information be generated to a log or trace file? Is
> auditing the way to go?
>
> Thanks
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jul 21 2000 - 00:00:00 CDT