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).
