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

From: Hemant K Chitale <hemantkchitale@xxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Sent: Wed, November 10, 2010 8:43:09 PM
Subject: Dynamic sampling

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
sent from my smartphone


Other related posts: