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_P8_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).