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

  • From: "Rich Jesse" <rjoralist2@xxxxxxxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 12 Oct 2012 10:51:45 -0500 (CDT)

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

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


Other related posts: