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@xxxxxxxxxxxxx=20 > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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. -- //www.freelists.org/webpage/oracle-l