RE: proper db_file_multiblock_read_count

david, take a look at ixora.com.au, steve adam has few scripts on how to do this...
it sets event 10046 to trace the event .....

Regards
Rahul

> ----------
> From: David Jones[SMTP:djones1688_at_hotmail.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, October 04, 2001 2:39 AM
> To: Multiple recipients of list ORACLE-L
> Subject: proper db_file_multiblock_read_count
>
> 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: djones1688_at_hotmail.com
>
> 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: ListGuru_at_fatcity.com (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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  INET: rahul_at_ratelindo.co.id

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: ListGuru_at_fatcity.com (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).