Re: Dynamic sampling

From: Kellyn Pedersen <>
Date: Wed, 10 Nov 2010 22:10:05 -0800 (PST)
Message-ID: <>

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 <>
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

Received on Thu Nov 11 2010 - 00:10:05 CST

Original text of this message