Re: plan stability
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Mon, 14 Sep 2009 19:34:51 +0200
Message-ID: <4aae7eba$0$2860$ba620e4c_at_news.skynet.be>
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
Date: Mon, 14 Sep 2009 19:34:51 +0200
Message-ID: <4aae7eba$0$2860$ba620e4c_at_news.skynet.be>
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. Received on Mon Sep 14 2009 - 12:34:51 CDT