Re: Dynamic sampling


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: