Re: performance issue after upgrade to oracle 11.2.0.1 linux 32 bit.

From: lsllcm <lsllcm_at_gmail.com>
Date: Sun, 8 Nov 2009 07:24:06 -0800 (PST)
Message-ID: <e43079ed-b13a-4410-a94d-d7a94177a65c_at_d9g2000prh.googlegroups.com>

Thanks Charles and Randolf, I learned a lot about optimizer from this thread.

------------------------case

1------------------------------------------------

1. Use hint /*+ index(SD SETDETAILS_SETID_IX) */

Result: yes, the execution plan is different and use different index. I did not check it carefully.

------------------------item

2------------------------------------------------

Below are histogram of SYS_NC00017$

Yes, SYS_NC00017$ is function index column UPPER("SD"."SET_ID") in index SETDETAILS_SET_IX
It showed a strange IO cost in the 10053 trace file: cost_io

179769313486231570814527423731704356798070567525844996598917476803157260780--
028538760589558632766878171540458953514382464234321326889464182768467546703--
537516986049910576551282076245490090389328944075868508455133942304583236903--
222948165808559332123348274797826204144723168738177180919299881250404026184--

124858368.00 Received on Sun Nov 08 2009 - 09:24:06 CST