Re: My database is too fast

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 27 Jun 2003 13:08:31 +0100
Message-ID: <3efc33bf$0$10629$ed9e5944@reading.news.pipex.net>

select /*+ noparallel full(tab) */ count(*) from tab;

insert caffeine into billy;

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message
news:bdh69c$gr$1_at_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:08:31 CDT