Re: ORA-00001 causes MTS (shared) server to di

Can it be done with an alter system/session command?

This is good stuff, didn't know.. thanks.

On Thu, 29 Apr 2004 21:25:47 +0200, Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote:

>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 DBA

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Fri Apr 30 2004 - 11:19:00 CDT