Re: dbms_xplan + allstats
From: Greg Rahn <greg_at_structureddata.org>
Date: Fri, 25 Feb 2011 20:24:52 -0800
Message-ID: <AANLkTikTwfj=xus3a3aZmhmQANVL=XpiY-Q9fjHz2R6d_at_mail.gmail.com>
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
Date: Fri, 25 Feb 2011 20:24:52 -0800
Message-ID: <AANLkTikTwfj=xus3a3aZmhmQANVL=XpiY-Q9fjHz2R6d_at_mail.gmail.com>
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
On Fri, Feb 25, 2011 at 12:37 PM, Stephens, Chris
<Chris.Stephens_at_adm.com> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 25 2011 - 22:24:52 CST