Re: plan stability

From: DEV <sdpant_at_gmail.com>
Date: Mon, 14 Sep 2009 12:11:31 -0700 (PDT)
Message-ID: <59e6cb0d-5ecc-4fae-a679-0e417d372643_at_s21g2000prm.googlegroups.com>

On Sep 14, 10:34 am, "Gerard H. Pille" <g..._at_skynet.be> wrote:
> DEV wrote:
> > Oracle 10.2.0.3 EE on RHEL 4
> > I have two schemas (say schemaA and schemaB) with the same set of
> > table structures but the data could be different by just a little
> > bit.  The app is working fine on schemaA but is very CPU intensive on
> > schemaB, so I want the app to use the same plan as on on schemaA.  I
> > created an outline on schemaB with dbms_outln.create_outline with the
> > hash_value child_number from v$sql_plan.  checking the user_outlines
> > view the plan is not being used.  Any idea why?
> > TIA,
> > Dev
>
> Why would that plan be used?   RTFM, there is more to it than just creating an outline.

I read the Oracle manual. Can you give me the link to what you are talking about? If you just have to say RTFM and nothing stop responding. Received on Mon Sep 14 2009 - 14:11:31 CDT