Re: Re: help with estimate row count from asktom

Hi!

Statistics level ALL means TYPICAL + row source execution stats + timed_os_statistics.
If you want to switch to ALL for performance reasons, you can switch only row source stats on with parameter setting _rowsource_execution_statistics to true (on session level).

But I doubt it'll help in current case anyway.

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, December 30, 2003 9:19 PM

> anyone have a better way to do this? im going to post what you said
wolfgang on asktom and see what he has to say.
> >
> > From: Wolfgang Breitling <breitliw_at_centrexcc.com>
> > Date: 2003/12/30 Tue PM 12:09:33 EST
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > Subject: Re: help with estimate row count from asktom
> >
> > v$sql_plan_statistics (and consequently v$sql_plan_statistics_all) only
> > have data to show if statistics_level is set to ALL. You can set that at
> > the session level.
> > Has anyone done measurements on a busy system to evaluate what the
impact
> > is of setting that system-wide. The impression I have is that it is not
> > something I want to set in production all the time.
> >
> > At 08:39 AM 12/30/2003, you wrote:
> > >I have a very strict SLA and I posted a question on asktom about the
best
> > >way to get the 'estimate' of rows and return it to the user. Im getting
> > >'no data found'. anyone have ideas? Im on 9.2, tables are analyzed, and
Im
> > >in a DBA account.
> > >
> > >my question is at the bottom.
> > >
> >
>http://asktom.oracle.com/pls/ask/f?p=4950:8:352052922015846036::NO::F4950_P
8_DISPLAYID,F4950_P8_CRITERIA:1933814740032,
> > >
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > >--
> > >Author: <ryan_oracle_at_cox.net
> > > INET: ryan_oracle_at_cox.net
> > >
> > >Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > >San Diego, California -- Mailing list and web hosting services
> > >---------------------------------------------------------------------
> > >To REMOVE yourself from this mailing list, send an E-Mail message
> > >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > >the message BODY, include a line containing: UNSUB ORACLE-L
> > >(or the name of mailing list you want to be removed from). You may
> > >also send the HELP command for other information (like subscribing).
> >
> > Wolfgang Breitling
> > Oracle7, 8, 8i, 9i OCP DBA
> > Centrex Consulting Corporation
> > http://www.centrexcc.com
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Wolfgang Breitling
> > INET: breitliw_at_centrexcc.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <ryan_oracle_at_cox.net
> INET: ryan_oracle_at_cox.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).