The number of lines (operations) in the plan and the number of entries in the predicate list relate to the number of tables. The output doesn't tell me which table it used dynamic sampling on and for which operations. This is from a vendor's package. I was just complaining that I have to go through each table to determine where it used dynamic sampling. ---- unlike the line numbers which you can use to match operations to predicates and vice-versa. Hemant K Chitale http://hemantoracledba.blogspot.com sent from my smartphone On Nov 11, 2010 3:03 PM, "William Robertson" <william@xxxxxxxxxxxxxxxxxxxx> wrote: 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 <hemantkchital... Date: 11/11/2010 03:43 > > > AARGH! > > What you do when DBMS_XPLAN.DISPLAY_CURSOR shows a 190 line ... -- //www.freelists.org/webpage/oracle-l