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 -> Orbitz dumps RAC for better reliability

Orbitz dumps RAC for better reliability

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 18 Jul 2003 14:51:48 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703ECDC5D@lnewton.leeds.lfs.co.uk>


Hi Billy,

>> Here's one at you. I run the following SQL (no hints, just vanilla
>> flavoured SQL):
>> SELECT count(*) FROM very_large_table.

>> Less than 3 seconds laters (2.07 to be precise), I get an answer of
>> 77.8 million rows.

I see that database of your is *still* running too fast. Didn't you manage to get it fixed ?
:o)

Cheers,
Norman.

--
-----------------------------------------------------------------
Norman Dunbar (at home on Linux)
Oracle_at_mssqlBountifulSolutions.co.uk

(Delete a Microsoft database name to reply - clue, mssql !)
-----------------------------------------------------------------
Received on Fri Jul 18 2003 - 08:51:48 CDT

Original text of this message

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