RE: ora1652 question...

Chris,

There are two options:

1. Easier, but requires a bounce : Add the following event into init.ora

event="1652 trace name processstate level 10"

This will dump the processstate for processing that encounter an ORA-01652.

And you can even add the following to capture 1555 and 4031 errors

event="1555 trace name errorstack level 3" event="4031 trace name errorstack level 3"

**BUT**, keep _all_ 'event' lines together in the file (just as with utl_file_dir entries)

2. Harder (requires coding/testing), but better control and options:

Create a System-level ON SERVERERROR trigger and check for 1652 (among others) and record all the details into either alert.log (via dbms_system.ksdwrt call), database table, utl_file etc.

Hth,
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)

Disappointment is inevitable, but Discouragement is optional!

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

>-----Original Message-----
>From: Chris Stephens [mailto:ChrisStephens_at_affina.com]
>Sent: Tuesday, January 06, 2004 2:10 PM
>To: Multiple recipients of list ORACLE-L
>Subject: ora1652 question...
>
>
>Is there an event to set where I can identify any sql that
>receives a 1652
>error message?
>
>There is some process running each night in a reporting
>database that has
>been generating this error for the past week. I figured someone would
>complain. That didn't happen so I went and asked the
>reporting people if
>any of the reports were blowing up. They said no. I just set
>up statspack
>and will run that every 10 minutes tonight. I also have a
>query that will
>capture the session info on sessions currently sorting that I
>will run every
>10 minutes. Neither of the techniques are very direct. I
>would imagine
>there is an event to set so that I can generate a trace file.
>Any other
>suggestions of nailing this down would be appreciated.
>
>..and so I don't have to ask about events anymore...where do I
>find what
>event means what?
>
>Thanks,
>Chris
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Chris Stephens
> INET: ChrisStephens_at_affina.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).