Re: DBMS_SPM.LOAD_FROM_CURSOR_CACHE
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 12 Oct 2011 21:12:52 +0000 (UTC)
Message-ID: <pan.2011.10.12.21.12.52_at_gmail.com>
On Wed, 12 Oct 2011 20:53:08 +0000, Mladen Gogala wrote:
>
> Some people never learn. Thanks for helping me out. The mistake was
> conceptual.
Date: Wed, 12 Oct 2011 21:12:52 +0000 (UTC)
Message-ID: <pan.2011.10.12.21.12.52_at_gmail.com>
On Wed, 12 Oct 2011 20:53:08 +0000, Mladen Gogala wrote:
> On Wed, 12 Oct 2011 12:46:13 -0700, dombrooks wrote:
>
>> P.S. I provided a complete end-to-end demo in my post above that >> worked. Wouldn't the easiest thing to have done be to run that verbatim >> and show that it did not work?
>
> Some people never learn. Thanks for helping me out. The mistake was
> conceptual.
BTW, this opens a world of tuning possibilities. One can hint an execution plan, without actually changing the source code and wait for Oracle to come up with a better plan once in the future. This is huge!
-- http://mgogala.byethost5.comReceived on Wed Oct 12 2011 - 16:12:52 CDT