Re: db_block configuration

frandi_at_dsdata.it (Paolo Frandi) wrote in message news:<59f50fe.0109250725.6dfe99f6_at_posting.google.com>...
> Greetings....
>
> I have a Server with this hw configuration:
> 2 Pentium III 1 Ghz
> 2 GB Ram
> 8 x 18 GB 10K disk or 4 x 36 GB 10K disk configured in one logical
> disk in RAID 5
>
> On this server I'll install NT Server 4.0, Oracle Server 8.1.7 (with a
> 50 GB OLTP DB) and a development environment (Forte).
> I'll have 60 clients about to work during the day.
>
> I have a lot of information on the configuration of db or OS, but
> I would like to understand in deep how to relate the three following
> parameters:
>
> RAID stripe (or chunk) width;
> NTFS partition allocation unit size;
> ORACLE DB_Block size.
>
> thanks in advance,
> sincerely

The basic problem here is you have determined your hardware config, before determining the Oracle config. Now your Oracle config is going to be dependent on the hw config, and it should be the other way around.
Also, given the impact of RAID-5 for Oracle, and the generic advice NOT to use RAID-5 for your online redolog files, I think it is debatable to have *1 SINGLE* RAID-5 array for the complete config. As I understand your post, you have only one RAID-5 controller, so whatever happens, when the controller goes, the database goes. I don't see how you will be capable to get an acceptable performance for a 50 G database on a single RAID-5 array, especially if it is an OLTP database.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Wed Sep 26 2001 - 10:21:06 CEST