How can we find the value of SSTIOMAX ?(What is it for
9i ?)
Thanks,
Ravi.
--- Tim Gorman <tim_at_sagelogix.com> wrote:
> There is a MetaLink article #131530.1 on the
> constant SSTIOMAX which may
> provide some interesting reading on this topic
> surround "max I/O size" and
> the setting of DBFMRC. The article is over 2 years
> old -- not sure if it
> pertains to 9i or above...
>
> Wolfgang, please let us know how those 8-byte
> database blocks work for you,
> OK?
>
>
>
> on 9/11/03 8:44 PM, Wolfgang Breitling at
> breitliw_at_centrexcc.com wrote:
>
> > db_block_size=8, db_file_multiblock_read_count =
> 32
> >
> > That is a Peoplesoft ERP system, a hybrid of oltp
> and dss with heavy
> > reporting activity at month end. The dfmrc value
> was established through
> > trial and 10053 trace analysis. Some report sql
> still require use_hash
> > hints in order to avoid silly NL joins. Was
> looking forward to upgrading to
> > Oracle 9 with system statistics so that I could
> jack up dfmrc to the max
> > without nasty side-effect for the oltp part, but
> I'm essentially out of
> > that account now.
> >
> > As for finding the max operating system I/O size
> on windows (or any other),
> > just set dfmrc to some insanely high number and
> let Oracle figure out what
> > the OS wil bear.
> >
> > At 01:59 PM 9/11/2003 -0800, you wrote:
> >> Hello list, seeking your personal opinions and
> experiences about
> >> db_file_multiblock_read_count.
> >>
> >> What do you all set your db_block_size and
> db_file_multiblock_read_count
> >> to?
> >>
> >> How did you all come to decide that those
> values would suit your systems ?
> >>
> >> Any windoze user here who can tell me how can one
> find out the max operating
> >> system I/O size (on windows) in order to set
> db_file_multiblock_read_count ?
> >
> > Wolfgang Breitling
> > Oracle7, 8, 8i, 9i OCP DBA
> > Centrex Consulting Corporation
> > http://www.centrexcc.com
> >
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Tim Gorman
> INET: tim_at_sagelogix.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> 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!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ravi Kulkarni
INET: nandagokul_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Sat Sep 13 2003 - 15:04:24 CDT
