Database Administration (MOSC)

MOSC Banner

11.2.0.1 11GR2 connect_by_use_union all fails.

edited Mar 31, 2014 12:00PM in Database Administration (MOSC) 2 commentsAnswered

Hello,

I am dealing with a known issue of 11.2.0.1 SW. We have upgraded our Oracle SW from 11.1.0.7 to 11.2.0.1 and we have come against the known issue of bug 9920616 (connect_by_use_union_all fails).
I am overcoming this issue by running the commd below:

alter system set "_connect_by_use_unionall" = old_plan_mode SCOPE  memory;

However this is not a permanent solution since whenever the instance is restarted the setting is reset.

Could you guide me of how to overcome this issue by a permanent fix? May I set it somehow in init file? Just to let you know that our instance is getting started by pfile so is there any way to set the old plan mode in pfile?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center