| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re: help with estimate row count from asktom
Ryan,
I asked Tom that very question a while ago, here: http://asktom.oracle.com/pls/ask/f?p=4950:8:8900576360328284797::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:3489618933902,
The short answer is that he's using Intermedia for his searching, which has the 'ctx_query.count_hits' functionality. It's built-in to Intermedia.
-Mark
-----Original Message-----
From: ryan_oracle_at_cox.net [mailto:ryan_oracle_at_cox.net] Sent: Tue 12/30/2003 1:19 PM To: Multiple recipients of list ORACLE-L Cc: Subject: Re: Re: help with estimate row count from asktomim 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bobak, Mark INET: Mark.Bobak_at_il.proquest.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).Received on Tue Dec 30 2003 - 12:39:25 CST
 |
 |