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

From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Fri, 12 Oct 2012 10:51:45 -0500 (CDT)
Message-ID: <2c213d2361c72b4d9150295a6a529d74.squirrel_at_society.servebeer.com>



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
Received on Fri Oct 12 2012 - 17:51:45 CEST

Original text of this message