Why not set it to 25?
Jared
"Jeff Wiegard"
<[EMAIL PROTECTED] To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
ate.mn.us> cc:
Sent by: Subject: Solaris -
db_file_multiblock_read_count
[EMAIL PROTECTED]
11/19/01 01:20 PM
Please respond to
ORACLE-L
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: [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:
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).
