RE: ora1652 question...

John has already shown you how to generate a trace when an error is encountered via the 'events' mechanism.

If you would like to see what events are available, peruse the file $ORACLE_HOME/rdbms/mesg/oraus.msg if you are on *nix. If you are on win32, the file is unfortunately not available.

Start with error code 10000. There may or may not be an explanation for an event in that file.

Jared

On Tue, 2004-01-06 at 15:44, John Kanagaraj wrote:
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.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).