RE: 10g slowdown
- From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 12 Dec 2008 10:38:33 -0600 (CST)
Hey William,
You mentioned that you gathered stats on the table and indexes -- what
method did you use? Analyze or DBMS_STATS? Compute/estimate? Histograms?
Buckets? Etc.
Also, is the SQL you posted the actual statement or does SAP use bind
variables? I'm having an issue (again) right now with 10.1.0.5 and bind
variable peeking causing a query to go from sub-second to 10 minutes because
the first statement executed after the cursor was invalidated by stats
gathering uses skewed values in the binds.
From 90 minutes north of you in the Frozen Tundra,
Rich
> I agree with your assessment. This code is generated by SAP and there
> isn't anything I can do to change it. The explain plan shows a cost of
> 0 for the joins which tells me the CBO is smart enough to recognize this
> and ignore it.
>
> William
--
//www.freelists.org/webpage/oracle-l
Other related posts:
