RE: Setting event 1555

From: Nahata, Naveen (US - Hyderabad) <nnahata_at_deloitte.com>
Date: Wed, 10 Nov 2004 08:46:12 -0600
Message-Id: <35A6B4FC173FE3449C7ABB1AD17187AD092BD2@uscnt0418.us.deloitte.com>

We are on 9i (9.2.0.5). O/S HP-UX B.11.11

In few of the trace files I see the following PL/SQL Call stack and in others I don't see any SQL or PL/SQL.

• PL/SQL Call Stack ----- object line object handle number name c00000010da20668 0 CTXSYS.TEXTOPTSTATS c000000128c2f1f0 1 anonymous block c0000000ead14708 1918 package body SYS.DBMS_STATS c0000000ead14708 2143 package body SYS.DBMS_STATS c0000000ead14708 7948 package body SYS.DBMS_STATS c0000000ead14708 9617 package body SYS.DBMS_STATS c0000000ead14708 9657 package body SYS.DBMS_STATS c0000000e530a588 848 package body APPS.FND_STATS c0000000e530a588 603 package body APPS.FND_STATS c0000000e530a588 414 package body APPS.FND_STATS c0000000e090da00 1 anonymous block

I want to find more about the offending SQL(s), so that I know more about the errors.

That is the reason why I want to set event 1555.

Regards
Naveen=20

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org=20
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Connor McDonald
> Sent: Wednesday, November 10, 2004 7:28 PM
> To: Oracle Mailing List
> Subject: Re: Setting event 1555

>=20
>=20

> I didn't think ora-1555's were logged in the alert log on v8,=20
> and if you're on v9, the sql text
> should be in the alert log as well

>=20

> Connor

>=20

This message (including any attachments) contains confidential = information intended for a specific individual and purpose, and is = protected by law. If you are not the intended recipient, you should = delete this message. Any disclosure, copying, or distribution of this = message, or the taking of any action based on it, is strictly = prohibited.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 10 2004 - 08:42:27 CST