Re: Dynamic sampling
From: Kellyn Pedersen <kjped1313_at_yahoo.com>
Date: Wed, 10 Nov 2010 22:10:05 -0800 (PST)
Message-ID: <529356.62189.qm_at_web120211.mail.ne1.yahoo.com>
Date: Wed, 10 Nov 2010 22:10:05 -0800 (PST)
Message-ID: <529356.62189.qm_at_web120211.mail.ne1.yahoo.com>
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_at_gmail.com> To: ORACLE-L <oracle-l_at_freelists.org> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 11 2010 - 00:10:05 CST