There is a bug in 11.2.0.2 and 11.2.0.3 that causes worse plan.
need to add hint
/*+OPT_PARAM('_optimizer_use_feedback','false') */
to resolve the issue.
symptom:
first run --fast
second and onward runs --very slow
do 10046, you will see a lot of physical reads
query on v$sql, you will see the plan_hash_values are different.
Subscribe to:
Post Comments (Atom)
My own Mind Map program in Java script and Python
I had been searching online mindmap apps for my study for a while and never got one that I am really happy with. Then I asked myself what I...
No comments:
Post a Comment