Since on 11g, if licensed, a much better alterative is SQL Monitoring. http://download.oracle.com/docs/cd/E11882_01/server.112/e16638/instance_tune.htm#PFGRF94543 set long 10000000 set longchunksize 10000000 set linesize 200 select dbms_sqltune.report_sql_monitor(sql_id=>'&sql_id') from dual; -- for text version More: http://structureddata.org/2008/01/06/oracle-11g-real-time-sql-monitoring-using-dbms_sqltunereport_sql_monitor/ On Fri, Feb 25, 2011 at 12:37 PM, Stephens, Chris <Chris.Stephens@xxxxxxx> wrote: > 11.2.0.2 on RHEL > > I’m working on some SQL that suffers from some horrible cardinality estimate > problems due to dummy rows that screw up the columns stats. > > Everything was going fine this morning but for some reason I can’t get an > execution plan to show me the a-rows now. -- Regards, Greg Rahn http://structureddata.org -- //www.freelists.org/webpage/oracle-l
