Re: plan stability

From: Gerard H. Pille <>
Date: Mon, 14 Sep 2009 19:34:51 +0200
Message-ID: <4aae7eba$0$2860$>

DEV wrote:
> Oracle 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

Original text of this message