Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: 30GB table: Hardware performance issue ?
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 BortelReceived on Tue Mar 04 2003 - 14:48:07 CST
![]() |
![]() |