topic JFS parameters for ORACLE in Disk Enclosures

JFS parameters for ORACLE

George Nikoloudis_1 — Wed, 21 Nov 2001 13:07:59 GMT

Dear all

What is better to have a large or a small JFS fragmented block size between 1,2,4,8 KB?

When the FS block is 8KB and the fragment block is 2KB is the JFS performs 4 IO operations in order to fill up the 8KB block?

My DB has 8KB db_block size.

Re: JFS parameters for ORACLE

harry d brown jr — Wed, 21 Nov 2001 14:21:26 GMT

Block Size and File Size Although data storage space is often measured in megabytes (one MB = 1024 * 1024 bytes), the HP-UX operating system and Oracle7 Server each perform input and output in units of data storage called blocks. The size of the operating system blocks is not necessarily equal to Oracle blocks.

Oracle7 Server block size is not fixed. You can set its value when creating a database by changing the DB_BLOCK_SIZE parameter in the initsid.ora file.

Changing the Oracle block size can change Oracle performance, depending on the disk hardware, file system, and application. Experiment with different block sizes to see what is most efficient for your configuration. The default size 2 KB should be adequate for most circumstances, but some performance benefits can be gained by modifying the Oracle block size on your system.

http://otn.oracle.co.kr/docs/oracle78/hp/server.733/a43837_2/ch1.htm#X01068

live free or die
harry

Re: JFS parameters for ORACLE

Vincent Farrugia — Wed, 21 Nov 2001 14:22:46 GMT

Hello,

Follow this thread:

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xaee3d211e18ad5118ff10090279cd0f9,00.html

especially Jared Westgate's answer.

HTH,
Vince