Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help on understanding TKprof

Re: Help on understanding TKprof

From: Melgar <luis_melgar_at_yahoo.com>
Date: 8 Jan 2006 20:23:41 -0800
Message-ID: <1136666116.155655.144890@o13g2000cwo.googlegroups.com>


This execution plan is almost certainly NOT what is actually happening......

I cant express how much i thank you Jonathan ...

You give me the light i just need.

it happen that this particular instance has the defaults values of OPTIMIZER_INDEX_CACHING and OPTIMIZER_INDEX_COST_ADJ

stated that, the performance has increased in 40% at least.

: ) Received on Sun Jan 08 2006 - 22:23:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US