Operating System - HP-UX
1836382 Members
3256 Online
110100 Solutions
New Discussion

Oracle 8.0.5 Database...suggested block size???

 
Robert Hoey
Advisor

Oracle 8.0.5 Database...suggested block size???

HP-UX 10.20 on K580.

Good afternoon everyone.

We are going to use extent striping over three 18 GB disks which will contain an Oracle database. This is the first time I am working with Oracle and my biggest concern is the performance hit that we will take.

My question: Since we are using extent striping we are limited to the default system block size which is set to 8Kb. Has anyone had any performance problems running an Oracle Database on disks that are striped with an 8Kb block size?

Thanks in advance.
1 REPLY 1
Alexander M. Ermes
Honored Contributor

Re: Oracle 8.0.5 Database...suggested block size???

Hi there.
This should not cause any headache.
We run some databases here in Europe on V-class, N-class and K-class machines. We use the 8k blocksize for all our databases. This does not give any performance problems.
We use about 20 databases for Oracle Applications
with this setup, no probs. So i would say, go for it.
Rgds
Alexander M.- Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"