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: My database is too fast

Re: My database is too fast

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Fri, 27 Jun 2003 12:26:33 +0000
Message-ID: <bdh69c$gr$1@ctb-nnrp2.saix.net>


Norman Dunbar wrote:

> two things to try out :
>
> 1. Have another cup of coffee

Roger that. Will do so right now.

> 2. Remove said table from your obviously overlarge KEEP POOL :o)

Dammit. Wish it was that simpply. But the CBO insists on being clever and doing the count in parallel, using partition iteration on the local partition bitmap index.

I don't understand how the CBO can work as designed and not adhere to the low standards and expectations from most users...

<muttering> something must be wrong... working as designed.. what the hell next... developers that actually know what they're doing.. newbies actually reading the friggen manuals.. <mutter> <mutter> what is this world coming too.. best rap artist is white.. best golfer is black.. england beating the aussies in rugby.. <mutter>

-- 
Billy
Received on Fri Jun 27 2003 - 07:26:33 CDT

Original text of this message

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