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: 30GB table: Hardware performance issue ?

Re: 30GB table: Hardware performance issue ?

From: Frank <fvanbortel_at_netscape.net>
Date: Tue, 04 Mar 2003 21:48:07 +0100
Message-ID: <3E651107.50205@netscape.net>


Andras Kovacs wrote:
> I got the problem !
> Here is a solution if somebody has a similar problem:
> - We really had an IO limit on the SCSI driver it was running 90%
> - I modified the index on the table so now it includes the historical value
> The index is IDX_HISTORY( TIME_STAMP, ID, VALUE ).
> The query is running in 6 sec instead of 33sec.
> - The IO rate has fallen dramatically
> - An other good thing, the index has still the same size as before

Sounds like an IOT-constuct...

Apart from that, do you have all that data in one file? I can only see "it's 30GB" but I'm unclear whether it's the table, or the file.
My assumption (correct me if I'm wrong) is that partitioned tables gain a lot from being physically apart; like "you want april 2001 data? I'll give you this file."

-- 
Regards, Frank van Bortel
Received on Tue Mar 04 2003 - 14:48:07 CST

Original text of this message

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