Database DataWarehousing (MOSC)

MOSC Banner

Index using issue

edited Nov 20, 2013 10:25AM in Database DataWarehousing (MOSC) 2 commentsAnswered
Hi all,
We are facing a issue about index using.
when we start query without using optimizer_feature_enable(10.2.0.5) in HINT , we get full table sacn and so db file scattered read,more CPU. duration is 1h19
but when we put in HINT a optimizer_feature_enable(10.2.0.5)  sql , index is used., duration is 9 mn

hour db version : 11.2.0.3
the value of the parameter : optimizer_feature_enable=11.2.0.3
we has tested with the parameter : optimizer_feature_enable=10.2.0.5 and execute sql without using optimizer_feature_enable in HINT , we get full table sacn and so db file scattered read,more CPU. .  Duration is 1h19

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