Re: plan stability
From: DEV <sdpant_at_gmail.com>
Date: Sun, 13 Sep 2009 12:35:53 -0700 (PDT)
Message-ID: <ded63584-2ee0-44b6-8dda-60b99f3ea137_at_m7g2000prd.googlegroups.com>
On Sep 13, 12:05 pm, DEV <sdp..._at_gmail.com> 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
Date: Sun, 13 Sep 2009 12:35:53 -0700 (PDT)
Message-ID: <ded63584-2ee0-44b6-8dda-60b99f3ea137_at_m7g2000prd.googlegroups.com>
On Sep 13, 12:05 pm, DEV <sdp..._at_gmail.com> 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
Forgot to mention both the schemas are on the same database. Received on Sun Sep 13 2009 - 14:35:53 CDT