Dear listers: OS: Sun 5.7 VERITAS File System 3.3.3 VERITAS Volume Manager 3.0.4 Oracle Enterprise 8.1.6.3 DB block size 16K
I try to decide what will be the best value for the db_file_multiblock_read_count ? Can anyone according the following configuration and shed some insight. Thanks David Jones ITResource ================================================================= #### vxprint -ht Disk group: rootdg DG NAME NCONFIG NLOG MINORS GROUP-ID DM NAME DEVICE TYPE PRIVLEN PUBLEN STATE V NAME USETYPE KSTATE STATE LENGTH READPOL PREFPLEX PL NAME VOLUME KSTATE STATE LENGTH LAYOUT NCOL/WID MODE SD NAME PLEX DISK DISKOFFS LENGTH [COL/]OFF DEVICE MODE SV NAME PLEX VOLNAME NVOLLAYR LENGTH [COL/]OFF AM/NM MODE dg rootdg default default 0 979189957.1025.svl-bp-db01 dm disk01 c1t5d0s2 sliced 4095 71036928 - dm disk02 c1t5d1s2 sliced 4095 71036928 - dm disk03 c1t5d2s2 sliced 4095 71036928 - dm disk04 c1t5d3s2 sliced 4095 71036928 - v data01 fsgen ENABLED ACTIVE 184860672 SELECT data01-01 pl data01-01 data01 ENABLED ACTIVE 184860672 STRIPE 3/256 RW sd disk03-02 data01-01 disk03 614400 61620224 0/0 c1t5d2 ENA sd disk04-02 data01-01 disk04 614400 61620224 1/0 c1t5d3 ENA sd disk01-04 data01-01 disk01 9416704 61620224 2/0 c1t5d0 ENA # vxtunefs -p /dev/vx/dsk/data01 read_pref_io = 131072 read_nstream = 3 read_unit_io = 131072 write_pref_io = 131072 write_nstream = 3 write_unit_io = 131072 pref_strength = 20 buf_breakup_size = 262144 discovered_direct_iosz = 262144 max_direct_iosz = 6291456 default_indir_size = 8192 qio_cache_enable = 0 max_diskq = 6291456 initial_extent_size = 1 max_seqio_extent_size = 2048 max_buf_data_size = 8192 _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Jones INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
