RE: Where does GC grab historical SQL plans from?

> Hi Rich, just another idea for a workaround until you get to 11g - you could
> try creating a SQL Profile, or a Stored Outline to force the CBO to always
> choose the "good" plan - as long as it works okay for all the commonly used
> bind variable values.

Nothing to do with Friday the 13th, but as luck would have it, the particular ERP web app is a let-the-user-customize-what-they-want-to-see one, and everyone wants something different. Which, in turn, affects how the SQL's generated.

I do have a few SQL Profiles in place though for the most common ones. However, it seems like most of the time, I couldn't force the plan I knew was the correct one, and the profiler didn't seem to have enough information to generate it.

When profiles failed, I've done a few manually-edited Outlines (FUN!). But as this is the little slice of heaven known as 10.1 it's a hit-or-miss method, with the misses ending in ORA-600/ORA-7445s.

Thanks for the feedback! It's tough to type enough here to give folks a comprehensive picture of this tangled issue, as it's been a loooonnng learning process. :)

Rich

--
http://www.freelists.org/webpage/oracle-l