Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re: help with estimate row count from asktom

Re: Re: help with estimate row count from asktom

From: <ryan_oracle_at_cox.net>
Date: Tue, 30 Dec 2003 10:19:26 -0800
Message-ID: <F001.005DB46C.20031230101926@fatcity.com>


im concerned about hitting the v$views in production. we have 30,000 users. its either that or do counts. Its a requirement from the users.

not sure what to do. doesnt tom kyte do this on asktom?
>
> 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_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).
>

-- 
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).
Received on Tue Dec 30 2003 - 12:19:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US