Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00001 causes MTS (shared) server to di
On Thu, 29 Apr 2004 18:52:09 GMT, andreyNSPAM_at_bookexchange.net
(NetComrade) wrote:
>Sybrand,
>
>Could you please elaborate on how this would help diagnose?
>
>Thanks
>
>On Wed, 28 Apr 2004 23:38:51 +0200, Sybrand Bakker
><sybrandb_at_hccnet.nl> wrote:
>
>>tOn Wed, 28 Apr 2004 20:55:53 GMT, andreyNSPAM_at_bookexchange.net
>>(NetComrade) wrote:
>>
>>>Don't know what else we can do, besides tracing every session, which
>>>is not feasible, given database traffic.
>>
>>
>>Try setting event '1 trace name errorstack level 3' in your init.ora
>>
>>
>>--
>>Sybrand Bakker, Senior Oracle DBA
>
>.......
>We use Oracle 8.1.7.4 on Solaris 2.7 boxes
>remove NSPAM to email
It should dump the statement in error to the trace file, and the context it is called in.
It will fire only when you hit ora-0001. You can do this with any error number, BTW
-- Sybrand Bakker, Senior Oracle DBAReceived on Thu Apr 29 2004 - 14:25:47 CDT