Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 8.0.5 performance issues.

Robert Hoey
Advisor

Oracle 8.0.5 performance issues.

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? What is everyone else out there using for a block size on disks that contain an Oracle database?

Thanks in advance.
3 REPLIES
Joseph C. Denman
Honored Contributor

Re: Oracle 8.0.5 performance issues.

normaly the same as the OS. You will be fine using 8K block sizes.
If I had only read the instructions first??
Carlos Fernandez Riera
Honored Contributor

Re: Oracle 8.0.5 performance issues.


For online applications 8k block size is good for Oracle.

A block of 64k is used for datawarehouse environments.

You can tune multi_read_count( more or less) to 3 in init.ora, so each oracle read will read one block for each disk.
unsupported
Andreas D. Skjervold
Honored Contributor

Re: Oracle 8.0.5 performance issues.

Hi!
Here is how I see it ( if I have understand your question right!)

Using filsystems for data storage; any Oracle block size (db_block_size) which is a multiple of your 8k stripe size should be OK, since hp-ux is caching the blocks anyway.
If your're using raw devices (async I/O) the Oracle block sizes should be equal (8k), since Oracle is doing all the caching.

Andreas

Only by ignoring what everyone think is important, can you be aware of what everyone ignores!