Re: ora1652 question...

From: anu <anu_77_d_at_yahoo.com>
Date: Tue, 06 Jan 2004 15:49:25 -0800
Message-ID: <F001.005DBE17.20040106154925@fatcity.com>

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 <ChrisStephens@affina.com> 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: ChrisStephens@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@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).

Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes

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

Received on Tue Jan 06 2004 - 17:49:25 CST