Re: Dynamic sampling
- From: Kellyn Pedersen <kjped1313@xxxxxxxxx>
- To: hemantkchitale@xxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 10 Nov 2010 22:10:05 -0800 (PST)
Dynamically generate SQL on the list of tables involved for
dbms_stats.lock_table_stats and execute... :P
Don't worry, you don't have to thank me...:)
Kellyn Pedersen
Sr. Database Administrator
http://www.linkedin.com/in/kellynpedersen
www.dbakevlar.com
________________________________
From: Hemant K Chitale <hemantkchitale@xxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Sent: Wed, November 10, 2010 8:43:09 PM
Subject: Dynamic sampling
AARGH!
What you do when DBMS_XPLAN.DISPLAY_CURSOR shows a 190 line Plan with 205
entries in the Predicates section and then adds "dynamic sampling used".
Just venting my frustration.
Hemant K Chitale
http://hemantoracledba.blogspot.com
sent from my smartphone
Other related posts:
