Re: To RAID or not to RAID ??

Torsten Greiff <Torsten.Greiff_at_t-online.de> wrote in article <5jsl5a$4h$2_at_news00.btx.dtag.de>...
>
> We have a ORACLE DB on NT using Compaq Harware
>
> our config is:
>
> 1 RAID1 for system and online redo 2 GIG Net
> 1 RAID1 for Rollback and temporary TS 4 GIG Net
> 1 RAID1 for archives
> 1 RAID5* for Data TS 7 * 2 GIG
> 1 RAID5 for Index TS 7 * 2 GIG
>
> * hardware RAID5
>
> it's working fine and with excelent performance

I find it difficult to estimate what does "excellent" perfomance means in above context.

Are there any numbers available?
Something simple, like e.g. how long does it take to run
SELECT COUNT(*) FROM MY_TABLE
where MY_TABLE is something more or less significant (>= 10M rows ). For example what would be a good [real] time for SELECT COUNT(*) FROM MY_TABLE;
where NUM_ROWS=10M and AVG_ROW_LEN=160 ???

Thanks,
Serge Received on Wed Apr 30 1997 - 00:00:00 CDT