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

Home -> Community -> Usenet -> c.d.o.server -> Re: Table access slow (solved)

Re: Table access slow (solved)

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 12 Feb 2004 00:09:34 +0100
Message-ID: <c0ec3g$rf$1@news2.tilbu1.nb.home.nl>


Sybrand Bakker wrote:

> On 11 Feb 2004 03:33:50 -0800, homer_at_vodafone.es (Felipe Mart?nez)
> wrote:
>
>

>>Finally, it seems it was a CBO matter.
>>   I deleted statistics for all the tables and indexes envolved in
>>the problem query and report came out in just 1:40 minutes. Things are
>>normal now.... buf!
>>
>>   Thanks a million, Frank!
>>   If you ever come to Galicia mail me and you'll get drinks and
>>shellfish for free.

>
>
> Bummer,
> 'solving' a problem by downgrading to RBO.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

It's 7.3, Sybrand, remember? CBO was ... well, flakey, at best
-- 

Regards,
Frank van Bortel
Received on Wed Feb 11 2004 - 17:09:34 CST

Original text of this message

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