Jeff,
as jared pointed out already .. p3 for scattered read
is the number of blocks read .. so setting your
DB_Multi... to 25 would be the best you can achieve
for your platform ..
Deepak
- Jeff Wiegard <JWIEGARD_at_ngwmail.des.state.mn.us>
wrote:
> Hi.
>
> I was hoping for some confirmation here.
>
> I'm running 8.0.5 on Solaris 2.7, with block size
> set to 8192.
> There is no 'maxphys' parameter in /etc/system.
>
> After some testing, I've decided to set the
> db_file_multiblock_read_count = 24, based on the
> following:
>
> 1. SQL> alter session set
> db_file_multiblock_read_count = 1000;
>
> 2. select value from v$parameter where name =
> 'db_file_multiblock_read_count';
>
> This gave me a value = 128
>
> 3. alter session set events '10046 trace name
> context forever,
> level 8';
>
> 4. select /*+ FULL(t) */ count(*) from sys.source$
> t;
>
> The trace file gave me the following:
>
> WAIT #1: nam='db file scattered read' ela= 0 p1=1
> p2=660 p3=25
> WAIT #1: nam='db file scattered read' ela= 0 p1=1
> p2=1167 p3=25
> WAIT #1: nam='db file scattered read' ela= 0 p1=1
> p2=1207 p3=25
> WAIT #1: nam='db file scattered read' ela= 0 p1=1
> p2=1272 p3=25
> WAIT #1: nam='db file scattered read' ela= 0 p1=1
> p2=1312 p3=25
>
> So then setting db_file_multiblock_read_count to 24
> would be about
> right ... right?
>
> Thanks,
>
> Jeff
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Jeff Wiegard
> INET: JWIEGARD_at_ngwmail.des.state.mn.us
>
> 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).
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deepak Thapliyal
INET: deepakthapliyal_at_yahoo.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).
Received on Mon Nov 19 2001 - 17:04:38 CST