Linux

Ask something
Discussion Locked

Unix/Oracle Block size

0 helpful
5 replies

by chiwendb

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

If you have Unixware 7 as the operating system and Oracle as a Database, What is the
recommended Block size which should be used in order for the two to run without any problems.
Please help.

Boniface Chiwenda

5 replies

by peter marshall

By default Oracle looks for an 8K block size. I am not sure of the Unixware 7 requirement byt Solaris and Oracle work without any problems when you create the file system with a blok size of 8K

Cheers
Peter

by william shipway

It is recommended to use the same block size in Unixware as you use for Oracle. The Oracle default is 8k as mentioned above.

However this is not a requirement. You can safely use 4k or 16k Unixware block sizes. It just means that you will havea small impact on system performance.

The Oracle web site has a whitepaper about selecting suitable block sizes for best performance. Can't remember the name of it sorry but try a search on their site.

HTH
William

This discussion is closed to new replies.