You could also use a trigger to get the info to a temp table as follows. This will probably fire after any error and could be performance hit. (happy new year to all). :
create or replace trigger system.server_1652_error_trig
after servererror
on database
declare
v_audsid number;
v_username varchar2(40);
begin
if (ora_server_error(1) = 01652) then
Chris Stephens <[EMAIL PROTECTED]> wrote:
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).
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
