Database DataWarehousing (MOSC)

MOSC Banner

_mv_refresh_use_hash_sj not working on 11.2.0.3

edited Mar 27, 2014 1:20PM in Database DataWarehousing (MOSC) 4 commentsAnswered

I tried
alter system set "_mv_refresh_use_hash_sj" = false
on Linux 64-bit 11.2.0.3
but materialized view refresh insert sql contains /*+ HASH_SJ */ hint.

At the same time
alter system set "_mv_refresh_use_no_merge" = false
removes /*+ NO_MERGE("JV$") */ hint from materialized view refresh insert sql.

Can anybody tell me what can I do to make
_mv_refresh_use_hash_sj
working?


May be this problem fixed in some patch to 11gR2 or I must setup some other parameters?

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