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:[EMAIL PROTECTED] >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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
