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 impo
Allan Robertson"
tmail.com>cc: (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 F
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 10
> 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, b
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 e
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) 538-505
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 10
try the library at www.evdbt.com, there are papers there
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 13 Jun 2001 15:14:40 -0800
> A trace event which will show you what the cost-based optimizer
considered
> before choosing a certain str