topic Re: OS read buffer size - I/O channel in Operating System - HP-UX

OS read buffer size - I/O channel

Raj Patel_1 — Tue, 03 Apr 2001 10:08:17 GMT

How do I determine the OS read buffer size on an HPUX system? I have an 8k db_block_size and want to correctly determine the db_multi_block_read_count parameter.

Re: OS read buffer size - I/O channel

Edward Sedgemore — Tue, 03 Apr 2001 10:30:26 GMT

If you have an 8k db block size in Oracle then you want to match this with the blocksize of the logical volume.
To find out what it is;

fstyp -v | grep bsize

The normal blocksize for JFS filesystems is 8k anyway.

Re: OS read buffer size - I/O channel

Printaporn_1 — Tue, 03 Apr 2001 10:31:01 GMT

Hi Raj,

hfs block size is 8k and jfs is 1k , but may be this is not what you want :

following is topic about db_multi_block_read_count

---------------
It depends on what kind of application (DSS,OLTP) your database is running. Increasing DB_FILE_MULTIBLOCK_READ_COUNT doesnt always increase performance. Other factors like size of tables and whether parallel query is being utilized come into the picture. Unlike db_file_mult_read_cnt which is primarily for I/O performance, DB_BLOCK_SIZE affects other parameters like the maximum value of the 'freelists' storage param for tables and indexes. Increasing db_block_size also requires recreating your whole database with a larger block size. I dont think it's worthwhile to do that just for a small performance increase in I/O. So increasing one or the other is definitely not the same. I would increase the DB_file_mult... if I/O performace was an issue and test the results first.
--------------
this is from oracle metalink

why not start at 16 ?