Mogens,
Thanks. Jonathan Lewis' book does talk about setting events. Thanks for
that tip and the example.
- Greg
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
A session trace on event 10053 CBO detail for a plan
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 13 Jun 2001 12:00:37 -0800
I have limited access to the client and time availavble so want to avoid
10053 traces at present.
What's a 10053
I have recently been called onto a client site where they are having some
performance issues with an OLTP db.
If I outline the situation you will see some of the obvious problems, but I
having a couple of problems identifying the reason for differences in the
execution path of a couple of
To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
tmail.comcc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
Sent by: Subject: Oracle 8i server vs Oracle
8i EE
I have limited access to the client and time availavble so want to avoid
10053 traces at present.
What's a 10053 trace?
- Greg
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
A trace event which will show you what the cost-based optimizer considered
before choosing a certain strategy. Way cool, but very internal in its format
:).
Greg Moore wrote:
I have limited access to the client and time availavble so want to avoid
10053 traces at present.
What's a 10053
A trace event which will show you what the cost-based optimizer considered
before choosing a certain strategy. Way cool, but very internal in its
format
Do you know of a good source for learning generally about setting events and
in particular, event 10053? It must be in the documentation,
Perhaps Jonathan Lewis' book talk about it? I'm not sure, and my people keep
stealing it from me, so I can't check. The book is listed under --- books! ---
on our website along with Gaja's.
Here's some documentation about 10053. I've also attached a sample trace file
resulting from setting this