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.
Wednesday, November 12, 2014
Subscribe to:
Posts (Atom)
Added more to my mindmap tool
This essay version allows you to add long essays to each topic. https://www.free-mindmap.com/Mindmap4LawSchoolEssay.html As I promised, the...
-
This essay version allows you to add long essays to each topic. https://www.free-mindmap.com/Mindmap4LawSchoolEssay.html As I promised, the... -
prompt ==================================================== prompt == Start of check_cursor.sql prompt ===================================...
-
Which two are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.) A. It analyzes a period of time corresponding to ...