Re: db_file_multiblock_read_count

If it would be a preprocessor define, you wouldn't see it.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Saturday, September 13, 2003 3:39 PM

> Connor rules.
>
> Tim Gorman wrote:
>
> >I've performed "nm -o oracle" and "strings -a oracle" on the Oracle
> >executable, searching for the phrase "sstiomax" to no avail. To me, that
> >implies that SSTIOMAX is not a variable in the "C" program that is
Oracle.
> >Instead, by C programmer conventions, any name expressed in all
upper-case
> >would most likely be a "#define" constant and not a variable, which is
> >impossible to display without source code or the ability to read object
> >code. Without source code access, of course, this is just a guess, as
> >conventions can be ignored.
> >
> >You can likely deduce SSTIOMAX by setting DBFMBRC to some insanely high
> >value then performing a FULL table scan under SQL trace level-8 as
specified
> >in "http://www.oracledba.co.uk/tips/mbrc.htm".
> >
> >Of course, this web page was found by searching Google using the search
> >phrase "sstiomax"...
> >
> >
> >
> >on 9/13/03 1:04 PM, Ravi Kulkarni at nandagokul_at_yahoo.com wrote:
> >
> >
> >
> >>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
> >>
> >>
> >
> >
> >
>
>
> Hesin e-postur er kannapur fyri virus av Fxroya Tele.
>
> This e-mail was virus scanned by Faroese Telecom.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
> INET: mln_at_miracleas.dk
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Anjo Kolk
  INET: anjo_at_oraperf.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).