RE: Setting event 1555
- From: "Nahata, Naveen (US - Hyderabad)" <nnahata@xxxxxxxxxxxx>
- To: <hamcdc@xxxxxxxxxxx>, "Oracle Mailing List" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 10 Nov 2004 08:46:12 -0600
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
Other related posts:
