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

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: