What have the number of lines in the plan and the predicates section got to do with dynamic sampling? Are you saying dynamic sampling is a bad thing? It seems like an excellent feature to me. William Robertson -------- Original Message -------- Subject: Dynamic sampling From: Hemant K Chitale <hemantkchitale@xxxxxxxxx> To: ORACLE-L <oracle-l@xxxxxxxxxxxxx> Date: 11/11/2010 03:43
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.
-- //www.freelists.org/webpage/oracle-l