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:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > 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: [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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul 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).
