And just to add, even the SSTIOMAX is "unachievable"
if other things get in the way.
For example, on Solaris 8.1 if you set
db_file_multiblock_read_count to (say) 1000 on an 8k
blocksize, you'll see in v$parameter sizes it down to
128 (indicating a 1M SSTIOMAX).
But do a full table scan with the 10046 trace and
you'll typically the best obtained in 16 or 32, mainly
because of the default Solaris maxphys setting, or
file system restrictions, or Veritas vxio max size
restrictions.
You've got to get them all correct to get the full
SSTIOMAX that Oracle can offer.
hth
connor
--- K Gopalakrishnan <[EMAIL PROTECTED]> wrote: >
Rahul,
>
> Actually there is a kernel constant SSTIOMAX which
> overrides the db_file_multiblock_read_count if you
> set that to higher values than SSTIOMAX.
>
> ANd this SSTIOMAX is very much OS/version/hardware
> dependent. What is your block size? Is it 2K (since
> you have set db_file_multiblock_read_Ccount to 32).
>
> How are you tracing that value? Have you set the
> event 10046 or just selecting from the
> V$session_event?
>
> Best Regards,
> K Gopalakrishnan
> Bangalore, INDIA
>
>
_________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at
> http://mail.yahoo.com
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: K Gopalakrishnan
> 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).
=====
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
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).
