Hi,

Ours is a Non-RAC environment. But, still following statement worked.

alter system reset "_push_join_union_view" scope=spfile sid='*';

I wonder if there are any other alternates available.

Thanks,

Sam