Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: show errors
This will not work, as the error tables track pl/sql compilation errors
only. The only way to track user-errors is setup the audit mechanism
and audit every unsuccessful statement and/or put the database in trace.
Hth,
Sybrand Bakker, Oracle DBA
In article <374ba8e0.0_at_145.227.194.253>,
"Mark Gumbs" <mgumbs_at_nospam.hotmail.com> wrote:
> Look at user_errors
>
> M
>
> Doug Cowles wrote in message <374B1F8B.C216F885_at_bigfoot.com>...
> >What table does show errors query? Someone reported a rollback
problem
> >but wasn't particular about what it was. Snapshot too old, not
enough
> >etc.,
> >I don't know. I'd like to find out. Can I query the error table to
> >find out?
> >
> >- Dc.
> >
>
>
--
Sybrand Bakker, Oracle DBA
All standard disclaimers apply
--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 26 1999 - 07:33:24 CDT
![]() |
![]() |