RE: Need some 10053 Guidance to help me solve a puzzler (*IGNORE* adjusted _optimizer_max_permutations, cost_based_transformation)

For each test, I run dbms_pool.purge with the address/hash values of the previous queries.

Chris

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich Jesse Sent: Friday, October 12, 2012 10:52 AM
To: oracle-l_at_freelists.org
Subject: RE: Need some 10053 Guidance to help me solve a puzzler (*IGNORE* adjusted _optimizer_max_permutations, cost_based_transformation)

Hey Chris,

> IGNORE that information as something else appears to be going on.
>
> When unsetting optmaxperm and optcbtransform I'm getting the better plan now
> by default.

I would hope that you would see the same as the cursor should not have been invalidated. You'd need to go to your pool flushing thread to make 'er go bye-bye first, or was that implied?

In either case, you're earning your beer this weekend... :9

Rich

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


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