Re: db_file_multiblock_read_count

[Anjo Kolk]

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

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
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 [EMAIL PROTECTED] wrote:
> >
> >
> >
> >>How can we find the value of SSTIOMAX ?(What is it for
> >>9i ?)
> >>
> >>Thanks,
> >>Ravi.
> >>--- Tim Gorman <[EMAIL PROTECTED]> 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
> >>>[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
> >>>
> >>>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: [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).
> >>>
> >>>
> >>__
> >>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: [EMAIL PROTECTED]
>
> Fat City Network Services-- 

Re: db_file_multiblock_read_count

[Mogens Nørgaard]

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 [EMAIL PROTECTED] wrote:

 

How can we find the value of SSTIOMAX ?(What is it for
9i ?)
Thanks,
Ravi.
--- Tim Gorman <[EMAIL PROTECTED]> 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
[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [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).
 

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
   

 



Hesin e-postur er kannaður fyri virus av Føroya 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: [EMAIL PROTECTED]
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: [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).

Re: db_file_multiblock_read_count

[Tim Gorman]

Another member of this list was once (possibly still is?) responsible for an
application with a database whose DB_BLOCK_SIZE was set to 4608.  Mind you,
it was most certainly not their choice, but instead was mandated by the
vendor.

The reasoning for the setting?  A "very important" table in this application
was deemed to have an average row width of about 4100-4500 bytes or so.  The
rest you can guess...




on 9/13/03 2:29 PM, Wolfgang Breitling at [EMAIL PROTECTED] wrote:

> Great. Can keep lots of blocks in the buffer pool. Hit ratio is at 110%
> Try it out some time.
> 
> At 07:49 AM 9/13/2003 -0800, you wrote:
> 
>> Wolfgang, please let us know how those 8-byte database blocks work for you,
>> OK?
> 
> Wolfgang Breitling
> Centrex Consulting Corporation
> http://www.centrexcc.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

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: [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).

Re: db_file_multiblock_read_count

[Wolfgang Breitling]

Great. Can keep lots of blocks in the buffer pool. Hit ratio is at 110%
Try it out some time.
At 07:49 AM 9/13/2003 -0800, you wrote:

Wolfgang, please let us know how those 8-byte database blocks work for you,
OK?
Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 INET: [EMAIL PROTECTED]
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: [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).

Re: db_file_multiblock_read_count

[Tim Gorman]

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 [EMAIL PROTECTED] wrote:

> How can we find the value of SSTIOMAX ?(What is it for
> 9i ?)
> 
> Thanks,
> Ravi.
> --- Tim Gorman <[EMAIL PROTECTED]> 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
>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
>> 
>> 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: [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).
> 
> 
> __
> 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: Tim Gorman
  INET: [EMAIL PROTECTED]

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: [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).

Re: db_file_multiblock_read_count

[Ravi Kulkarni]

How can we find the value of SSTIOMAX ?(What is it for
9i ?)

Thanks,
Ravi.
--- Tim Gorman <[EMAIL PROTECTED]> 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
> [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
> 
> 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: [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).


__
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: [EMAIL PROTECTED]

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: [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).

Re: db_file_multiblock_read_count

[Tim Gorman]

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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED]

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: [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).

Re: db_file_multiblock_read_count

[Wolfgang Breitling]

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: Wolfgang Breitling
 INET: [EMAIL PROTECTED]
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: [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).

RE: db_file_multiblock_read_count + db file scattered read +

[Cary Millsap]

I would expect the pread64() calls to map to "db file sequential read" and
the readv() calls to map to "db file scattered read". Jeff's "Why are
Oracle's Read Events 'Named Backwards'?" explains (www.hotsos.com/catalog).


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic 101, Mar 25-27 Oxford
- Hotsos Clinic 101, Apr  8-10 Chicago


-Original Message-
Ildefonso N
Sent: Thursday, March 13, 2003 12:44 PM
To: Multiple recipients of list ORACLE-L

Thanks Wolfgang, Cary for taking the time to answer my first question. After
taking a second look on the hotsos doc, it did in fact address my problem,
specifically the third bullet point. I simply missed to apply the pattern,
shown in the example for the third point, to my situation. 

As for pread64/readv, after looking at the whole truss output, I did not
find a single read using readv() that exceeded 128K, although, I found some
pread64() that were less than 128K, which I am guessing is due to "db file
sequential reads".

-Original Message-
Sent: Wednesday, March 12, 2003 10:14 PM
To: Multiple recipients of list ORACLE-L


My explanation is that blocks 1473, 2566, 2580, 2590, 2617, 2628, 2648, 
2681, 2695, 2702, 2714, 2719, 2748, 2760, 2773, 2794, 2798, 2811, and 2819 
were already in the buffer pool and the FTS reads "around" them.

At 08:08 PM 3/12/2003 -0800, you wrote:
>I have been wondering how to set the optimal value of dfmbc
>(db_file_multiblock_read_count),  filesystem pagesize/blocksize, db blk
>size, in an effort to optimize FTS.
>
>I have done testing using event 10046 and truss to find the p3 value on the
>db file scattered then comparing it with the truss output. It seems that
the
>value in trace file corelates to the truss value (pread64/readv), but I am
>having trouble trying to explain why lines 12 and 21 on both output files
>are not using the dfmbc setting of 128 (1M) on the fetch? Also, why is
truss
>showing pread64 and then readv on lines 24..32? I have read the hotsos doc
>"Predicting Multi-Block Read Call Sizes" (by Jeff Holt) to get some
>understanding on how dfmbc affects database I/O. It did not answer cover,
>though my situation, because the object does not cross extent boundary.
>
>Any answers would be highly appreciated. Your collective knowledge would
>surely help. Any info to other docs or links would also be valuable.
>
>Here is the output of event 10046, truss and other info of the test env.
>
>  1  WAIT #3: nam='db file scattered read' ela= 6 p1=10 p2=10 p3=128
>  2  WAIT #3: nam='db file scattered read' ela= 9 p1=10 p2=138 p3=128
>  3  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=266 p3=128
>  4  WAIT #3: nam='db file scattered read' ela= 3 p1=10 p2=394 p3=128
>  5  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=522 p3=128
>  6  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=650 p3=128
>  7  WAIT #3: nam='db file scattered read' ela= 5 p1=10 p2=778 p3=128
>  8  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=906 p3=128
>  9  WAIT #3: nam='db file scattered read' ela= 6 p1=10 p2=1034 p3=128
> 10  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=1162 p3=128
> 11  WAIT #3: nam='db file scattered read' ela= 3 p1=10 p2=1290 p3=128
> 12  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=1418 p3=55
> 13  WAIT #3: nam='db file scattered read' ela= 6 p1=10 p2=1474 p3=128
> 14  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=1602 p3=128
> 15  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=1730 p3=128
> 16  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=1858 p3=128
> 17  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=1986 p3=128
> 18  WAIT #3: nam='db file scattered read' ela= 5 p1=10 p2=2114 p3=128
> 19  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=2242 p3=128
> 20  WAIT #3: nam='db file scattered read' ela= 3 p1=10 p2=2370 p3=128
> 21  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2498 p3=68
> 22  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2567 p3=13
> 23  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2581 p3=9
> 24  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2591 p3=26
> 25  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2618 p3=10
> 26  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2629 p3=19
> 27  WAIT #3: nam='db file scattered read' ela= 9 p1=10 p2=2649 p3=32
> 28  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2682 p3=13
> 29  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2696 p3=6
> 30  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2703 p3=11
> 31  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2715 p3=4
> 32  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2720 p3=28
> 33  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2749 p3=11
> 34  WAIT #3: nam='db file scattered re

RE: db_file_multiblock_read_count + db file scattered read +

[Erroba, Ildefonso N]

Thanks Wolfgang, Cary for taking the time to answer my first question. After
taking a second look on the hotsos doc, it did in fact address my problem,
specifically the third bullet point. I simply missed to apply the pattern,
shown in the example for the third point, to my situation. 

As for pread64/readv, after looking at the whole truss output, I did not
find a single read using readv() that exceeded 128K, although, I found some
pread64() that were less than 128K, which I am guessing is due to "db file
sequential reads".

-Original Message-
Sent: Wednesday, March 12, 2003 10:14 PM
To: Multiple recipients of list ORACLE-L


My explanation is that blocks 1473, 2566, 2580, 2590, 2617, 2628, 2648, 
2681, 2695, 2702, 2714, 2719, 2748, 2760, 2773, 2794, 2798, 2811, and 2819 
were already in the buffer pool and the FTS reads "around" them.

At 08:08 PM 3/12/2003 -0800, you wrote:
>I have been wondering how to set the optimal value of dfmbc
>(db_file_multiblock_read_count),  filesystem pagesize/blocksize, db blk
>size, in an effort to optimize FTS.
>
>I have done testing using event 10046 and truss to find the p3 value on the
>db file scattered then comparing it with the truss output. It seems that
the
>value in trace file corelates to the truss value (pread64/readv), but I am
>having trouble trying to explain why lines 12 and 21 on both output files
>are not using the dfmbc setting of 128 (1M) on the fetch? Also, why is
truss
>showing pread64 and then readv on lines 24..32? I have read the hotsos doc
>"Predicting Multi-Block Read Call Sizes" (by Jeff Holt) to get some
>understanding on how dfmbc affects database I/O. It did not answer cover,
>though my situation, because the object does not cross extent boundary.
>
>Any answers would be highly appreciated. Your collective knowledge would
>surely help. Any info to other docs or links would also be valuable.
>
>Here is the output of event 10046, truss and other info of the test env.
>
>  1  WAIT #3: nam='db file scattered read' ela= 6 p1=10 p2=10 p3=128
>  2  WAIT #3: nam='db file scattered read' ela= 9 p1=10 p2=138 p3=128
>  3  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=266 p3=128
>  4  WAIT #3: nam='db file scattered read' ela= 3 p1=10 p2=394 p3=128
>  5  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=522 p3=128
>  6  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=650 p3=128
>  7  WAIT #3: nam='db file scattered read' ela= 5 p1=10 p2=778 p3=128
>  8  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=906 p3=128
>  9  WAIT #3: nam='db file scattered read' ela= 6 p1=10 p2=1034 p3=128
> 10  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=1162 p3=128
> 11  WAIT #3: nam='db file scattered read' ela= 3 p1=10 p2=1290 p3=128
> 12  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=1418 p3=55
> 13  WAIT #3: nam='db file scattered read' ela= 6 p1=10 p2=1474 p3=128
> 14  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=1602 p3=128
> 15  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=1730 p3=128
> 16  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=1858 p3=128
> 17  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=1986 p3=128
> 18  WAIT #3: nam='db file scattered read' ela= 5 p1=10 p2=2114 p3=128
> 19  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=2242 p3=128
> 20  WAIT #3: nam='db file scattered read' ela= 3 p1=10 p2=2370 p3=128
> 21  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2498 p3=68
> 22  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2567 p3=13
> 23  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2581 p3=9
> 24  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2591 p3=26
> 25  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2618 p3=10
> 26  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2629 p3=19
> 27  WAIT #3: nam='db file scattered read' ela= 9 p1=10 p2=2649 p3=32
> 28  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2682 p3=13
> 29  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2696 p3=6
> 30  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2703 p3=11
> 31  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2715 p3=4
> 32  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2720 p3=28
> 33  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2749 p3=11
> 34  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2761 p3=12
> 35  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2774 p3=20
> 36  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2795 p3=3
> 37  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2799 p3=12
> 38  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2812 p3=7
> 39  WAIT #3: nam='db file scattered read' ela= 5 p1=10 p2=2820 p3=128
> 40  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2948 p3=128

Wolfgang Breitling

Re: db_file_multiblock_read_count + db file scattered read + truss

[Jonathan Lewis]

Purely a guess, but looking at the figures
do you think that Oracle is using readv for
values up to 128K, and pread for values
larger than 128K ?


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Now available One-day tutorials:
  Cost Based Optimisation
  Trouble-shooting and Tuning
  Indexing Strategies

(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___April 8th
UK___April 22nd

Denmark May 21-23rd

USA_(FL)_May 2nd


Next dates for the 3-day seminar:
(see http://www.jlcomp.demon.co.uk/seminar.html )

UK_(Manchester)_May
USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message -
> 20  WAIT #3: nam='db file scattered read' ela= 3 p1=10 p2=2370
p3=128
> 21  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2498
p3=68
> 22  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2567
p3=13
> 23  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2581
p3=9
> 24  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2591
p3=26

> 20  pread64(409, "0602\0\00280\t BDEF5 6E2".., 1048576,
0x01284000) = 1048576
> 21  pread64(409, "0602\0\00280\tC2DEF5 6E2".., 557056,
0x01384000) = 557056
> 22  readv(409, 0xFFBE927C, 13)  = 106496
> 23  readv(409, 0xFFBE927C, 9)   = 73728
> 24  pread64(409, "0602\0\00280\n1FDEF5 6E2".., 212992,
0x0143E000) =  212992


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: [EMAIL PROTECTED]

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: [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).

RE: db_file_multiblock_read_count + db file scattered read + truss

[Cary Millsap]

Jun,

Wolfgang is correct, and it is covered in Jeff's document. It's the third
point (with example) listed at the bottom of page 1.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic 101, Mar 25-27 Oxford
- Hotsos Clinic 101, Apr  8-10 Chicago


-Original Message-
Ildefonso N
Sent: Wednesday, March 12, 2003 10:09 PM
To: Multiple recipients of list ORACLE-L

I have been wondering how to set the optimal value of dfmbc
(db_file_multiblock_read_count),  filesystem pagesize/blocksize, db blk
size, in an effort to optimize FTS. 

I have done testing using event 10046 and truss to find the p3 value on the
db file scattered then comparing it with the truss output. It seems that the
value in trace file corelates to the truss value (pread64/readv), but I am
having trouble trying to explain why lines 12 and 21 on both output files
are not using the dfmbc setting of 128 (1M) on the fetch? Also, why is truss
showing pread64 and then readv on lines 24..32? I have read the hotsos doc
"Predicting Multi-Block Read Call Sizes" (by Jeff Holt) to get some
understanding on how dfmbc affects database I/O. It did not answer cover,
though my situation, because the object does not cross extent boundary. 

Any answers would be highly appreciated. Your collective knowledge would
surely help. Any info to other docs or links would also be valuable.

Here is the output of event 10046, truss and other info of the test env. 

 1  WAIT #3: nam='db file scattered read' ela= 6 p1=10 p2=10 p3=128
 2  WAIT #3: nam='db file scattered read' ela= 9 p1=10 p2=138 p3=128
 3  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=266 p3=128
 4  WAIT #3: nam='db file scattered read' ela= 3 p1=10 p2=394 p3=128
 5  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=522 p3=128
 6  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=650 p3=128
 7  WAIT #3: nam='db file scattered read' ela= 5 p1=10 p2=778 p3=128
 8  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=906 p3=128
 9  WAIT #3: nam='db file scattered read' ela= 6 p1=10 p2=1034 p3=128
10  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=1162 p3=128
11  WAIT #3: nam='db file scattered read' ela= 3 p1=10 p2=1290 p3=128
12  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=1418 p3=55
13  WAIT #3: nam='db file scattered read' ela= 6 p1=10 p2=1474 p3=128
14  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=1602 p3=128
15  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=1730 p3=128
16  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=1858 p3=128
17  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=1986 p3=128
18  WAIT #3: nam='db file scattered read' ela= 5 p1=10 p2=2114 p3=128
19  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=2242 p3=128
20  WAIT #3: nam='db file scattered read' ela= 3 p1=10 p2=2370 p3=128
21  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2498 p3=68
22  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2567 p3=13
23  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2581 p3=9
24  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2591 p3=26
25  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2618 p3=10
26  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2629 p3=19
27  WAIT #3: nam='db file scattered read' ela= 9 p1=10 p2=2649 p3=32
28  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2682 p3=13
29  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2696 p3=6
30  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2703 p3=11
31  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2715 p3=4
32  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2720 p3=28
33  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2749 p3=11
34  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2761 p3=12
35  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2774 p3=20
36  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2795 p3=3
37  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2799 p3=12
38  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2812 p3=7
39  WAIT #3: nam='db file scattered read' ela= 5 p1=10 p2=2820 p3=128
40  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2948 p3=128

 1  pread64(409, "0602\0\00280\0\nDEF5 6 [".., 1048576, 81920) = 1048576
 2  pread64(409, "0602\0\00280\08ADEF5 6 [".., 1048576, 1130496) =
1048576
 3  pread64(409, "0602\0\0028001\nDEF5 6 [".., 1048576, 2179072) =
1048576
 4  pread64(409, "0602\0\00280018ADEDE tC3".., 1048576, 3227648) =
1048576
 5  pread64(409, "0602\0\0028002\nDEF5 6 [".., 1048576, 4276224) =
1048576
 6  pread64(409, "0602\0\00280028ADEF5 6 [".., 1048576, 5324800) =
1048576
 7  pread64(409, "0602\0\0028003\nDEF5 6 [".., 1048576, 6373376) =
1048576
 8  pread64(409, "0602\0\00280038ADEF5 6 [".

Re: db_file_multiblock_read_count + db file scattered read +

[Wolfgang Breitling]

My explanation is that blocks 1473, 2566, 2580, 2590, 2617, 2628, 2648, 
2681, 2695, 2702, 2714, 2719, 2748, 2760, 2773, 2794, 2798, 2811, and 2819 
were already in the buffer pool and the FTS reads "around" them.

At 08:08 PM 3/12/2003 -0800, you wrote:
I have been wondering how to set the optimal value of dfmbc
(db_file_multiblock_read_count),  filesystem pagesize/blocksize, db blk
size, in an effort to optimize FTS.
I have done testing using event 10046 and truss to find the p3 value on the
db file scattered then comparing it with the truss output. It seems that the
value in trace file corelates to the truss value (pread64/readv), but I am
having trouble trying to explain why lines 12 and 21 on both output files
are not using the dfmbc setting of 128 (1M) on the fetch? Also, why is truss
showing pread64 and then readv on lines 24..32? I have read the hotsos doc
"Predicting Multi-Block Read Call Sizes" (by Jeff Holt) to get some
understanding on how dfmbc affects database I/O. It did not answer cover,
though my situation, because the object does not cross extent boundary.
Any answers would be highly appreciated. Your collective knowledge would
surely help. Any info to other docs or links would also be valuable.
Here is the output of event 10046, truss and other info of the test env.

 1  WAIT #3: nam='db file scattered read' ela= 6 p1=10 p2=10 p3=128
 2  WAIT #3: nam='db file scattered read' ela= 9 p1=10 p2=138 p3=128
 3  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=266 p3=128
 4  WAIT #3: nam='db file scattered read' ela= 3 p1=10 p2=394 p3=128
 5  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=522 p3=128
 6  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=650 p3=128
 7  WAIT #3: nam='db file scattered read' ela= 5 p1=10 p2=778 p3=128
 8  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=906 p3=128
 9  WAIT #3: nam='db file scattered read' ela= 6 p1=10 p2=1034 p3=128
10  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=1162 p3=128
11  WAIT #3: nam='db file scattered read' ela= 3 p1=10 p2=1290 p3=128
12  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=1418 p3=55
13  WAIT #3: nam='db file scattered read' ela= 6 p1=10 p2=1474 p3=128
14  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=1602 p3=128
15  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=1730 p3=128
16  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=1858 p3=128
17  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=1986 p3=128
18  WAIT #3: nam='db file scattered read' ela= 5 p1=10 p2=2114 p3=128
19  WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=2242 p3=128
20  WAIT #3: nam='db file scattered read' ela= 3 p1=10 p2=2370 p3=128
21  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2498 p3=68
22  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2567 p3=13
23  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2581 p3=9
24  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2591 p3=26
25  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2618 p3=10
26  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2629 p3=19
27  WAIT #3: nam='db file scattered read' ela= 9 p1=10 p2=2649 p3=32
28  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2682 p3=13
29  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2696 p3=6
30  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2703 p3=11
31  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2715 p3=4
32  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2720 p3=28
33  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2749 p3=11
34  WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2761 p3=12
35  WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2774 p3=20
36  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2795 p3=3
37  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2799 p3=12
38  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2812 p3=7
39  WAIT #3: nam='db file scattered read' ela= 5 p1=10 p2=2820 p3=128
40  WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2948 p3=128
Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 INET: [EMAIL PROTECTED]
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: [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).

RE: db_file_multiblock_read_count

[Ravinder_Bahadur]

Nice colour choice ..



   
   
"Guy Hammond"  
   
   <[EMAIL PROTECTED]>
   
Sent by: cc:   
   
root@fatcity.    Subject: RE: 
db_file_multiblock_read_count   
com
   
   
   
   
   
25-Jun-2001
   
11:27 PM   
   
Please 
   
respond to 
   
ORACLE-L   
   
   
   
Sender Info:   
   
No Sender  
   
Info found in  
   
the address
   
Book   
   
   
   
   
   




Hi Lisa,

IIRC, the first line of vmstat gives you cumulative values since system
boot. And "2 10" means "every 2 seconds, 10 times" (on Solaris, at any
rate).

Cheers,

g

 -Original Message-
 From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
 Sent: Monday, June 25, 2001 3:23 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: db_file_multiblock_read_count



 2.  vmstat - look at the two columns that start with pg.  Read the man
 page and it will explain it to you in detail. Also, when you use
 vmstat be sure to give it an interval (like vmstat 2 10 - this means
 display stats once every 2 seconds for a duration of 10 seconds).  The
 first line returned by vmstat will always be garbage (same with
 iostat).









  
__

  Visit us at www.singaporeair.com.
  
__

-- 
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).

RE: db_file_multiblock_read_count/max i/o

[Koivu, Lisa]

Title: RE: db_file_multiblock_read_count/max i/o 





thanks Connor.  Excellent info. 


Lisa Koivu
Ft. Lauderdale, FL, USA


-Original Message-
From:   Connor McDonald [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, June 25, 2001 2:18 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: db_file_multiblock_read_count/max i/o 


alter session set db_file_multiblock_read_count =
32768;


enable event 10046 at level 8


do a large full scan


check the trace file, 'p3' tells you the max mb count
it could use, and thus the max io (from oracle's
perspective)


hth
connor


--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote: >
Um   that was something I relied upon my trusty
> SA to tell me.  
> I can't answer that.  Sorry.  Anyone know?  I do
> know how to determine this
> is different between platforms.  
> 
> Lisa
> 
> > -Original Message-
> > From:   Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
> > Sent:   Monday, June 25, 2001 11:12 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:    RE: db_file_multiblock_read_count
> > 
> > How do you tell for sure what the max i/o size is
> set to?
> > 
> > -Original Message-
> > Sent: Monday, June 25, 2001 9:23 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > 
> > Hi Liam, 
> > 
> > 1.  Setting db_file_multiblock_count to a number
> that when multiplied by
> > your block size is greater than your max i/o size
> on your host will
> > encourage full table scans.  I also read somewhere
> else about the effects
> > of
> > doing this, I know there's more to it than what
> I've stated, but I don't
> > remember off the top of my head (pre-coffee and
> post-run this am)
> > 
> > 2.  vmstat - look at the two columns that start
> with pg.  Read the man
> > page
> > and it will explain it to you in detail. Also,
> when you use vmstat be sure
> > to give it an interval (like vmstat 2 10 - this
> means display stats once
> > every 2 seconds for a duration of 10 seconds). 
> The first line returned by
> > vmstat will always be garbage (same with iostat).
> > 
> > HTH 
> > Lisa Koivu 
> > Petite Clumsy Ninja-ette 
> > Ft. Lauderdale, FL, USA 
> > 
> >     -Original Message- 
> > Sent:   Monday, June 25, 2001 8:36 AM 
> > To: Multiple recipients of list ORACLE-L 
> > 
> >     Listers, 
> > 
> >     I am attempting to tune a 7.3.4 OLTP database and
> I have a couple of
> > 
> > questions. 
> > 
> >     1. The db_file_multiblock_count is 64 which seems
> way too high to
> > me. What 
> > are the consequences, if any, of setting this
> parameter too high? 
> > 
> >     2. I want to increase the SGA to be 20% of the
> available memory
> > (currently 
> > about 10%). Once I've made the change how can I
> tell if the Unix machine
> > is 
> > paging memory without a fancy GUI tool? 
> > 
> >     Many thanks in advance, 
> > Liam 
> >
>
_
> 
> > Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com
> > <http://www.hotmail.com> . 
> > 
> >     -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > <http://www.orafaq.com>  
> > -- 
> > Author: Liam Morrin 
> >   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: Smith, Ron L.
> >   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

RE: db_file_multiblock_read_count/max i/o

[Christopher Spence]

Title: RE: db_file_multiblock_read_count/max i/o



Oracle 
will silently set it to the max setting for the platform.  Meaning the 
v$parameter will just show what you set it at reguardless of what the max 
is.  The only way is using truss type utility and monitor the system 
calls.
 
 
"Walking on water and developing software from a 
specification are easy if both are frozen." 
Christopher R. Spence Oracle DBA Fuelspot 

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, June 25, 2001 12:12 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  db_file_multiblock_read_count/max i/o 
  Um   that was something 
  I relied upon my trusty SA to tell me.  I can't answer that.  Sorry.  Anyone 
  know?  I do know how to determine this is different between 
  platforms.  
  Lisa 
  
-Original Message- From:   Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent:   Monday, June 25, 
2001 11:12 AM To: Multiple recipients of list ORACLE-L Subject:    RE: db_file_multiblock_read_count 
How do you tell for sure what the max i/o size is 
set to? 
-Original Message- Sent: Monday, June 25, 2001 9:23 AM To: Multiple recipients of list ORACLE-L 

Hi Liam, 
1.  Setting db_file_multiblock_count to a 
number that when multiplied by your block 
size is greater than your max i/o size on your host will encourage full table scans.  I also read somewhere 
else about the effects of doing this, I 
know there's more to it than what I've stated, but I don't remember off the top of my head (pre-coffee and post-run 
this am) 
2.  vmstat - look at the two columns that 
start with pg.  Read the man page and it will explain it to you in detail. Also, when you use vmstat be 
sure to give it an interval (like vmstat 
2 10 - this means display stats once every 2 seconds for a duration of 10 seconds).  The first line 
returned by vmstat will always be garbage 
(same with iostat). 
HTH Lisa Koivu 
Petite Clumsy Ninja-ette Ft. Lauderdale, FL, USA 
    -Original Message- Sent:   Monday, June 25, 2001 8:36 AM To: Multiple recipients of list 
ORACLE-L 
    Listers, 
    I am 
attempting to tune a 7.3.4 OLTP database and I have a couple of 
questions. 
    1. The 
db_file_multiblock_count is 64 which seems way too high to me. What are the 
consequences, if any, of setting this parameter too high? 
    2. I 
want to increase the SGA to be 20% of the available memory (currently about 10%). 
Once I've made the change how can I tell if the Unix machine is 
paging memory without a fancy GUI tool? 

    Many 
thanks in advance, Liam _ 
Get Your Private, Free E-mail from MSN 
Hotmail at http://www.hotmail.com <http://www.hotmail.com> . 
    -- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
<http://www.orafaq.com>  
-- Author: Liam Morrin   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: Smith, Ron 
L.   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). 

RE: db_file_multiblock_read_count/max i/o

[Connor McDonald]

alter session set db_file_multiblock_read_count =
32768;

enable event 10046 at level 8

do a large full scan

check the trace file, 'p3' tells you the max mb count
it could use, and thus the max io (from oracle's
perspective)

hth
connor

--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote: >
Um   that was something I relied upon my trusty
> SA to tell me.  
> I can't answer that.  Sorry.  Anyone know?  I do
> know how to determine this
> is different between platforms.  
> 
> Lisa
> 
> > -Original Message-
> > From:   Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
> > Sent:   Monday, June 25, 2001 11:12 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: db_file_multiblock_read_count
> > 
> > How do you tell for sure what the max i/o size is
> set to?
> > 
> > -Original Message-
> > Sent: Monday, June 25, 2001 9:23 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > 
> > Hi Liam, 
> > 
> > 1.  Setting db_file_multiblock_count to a number
> that when multiplied by
> > your block size is greater than your max i/o size
> on your host will
> > encourage full table scans.  I also read somewhere
> else about the effects
> > of
> > doing this, I know there's more to it than what
> I've stated, but I don't
> > remember off the top of my head (pre-coffee and
> post-run this am)
> > 
> > 2.  vmstat - look at the two columns that start
> with pg.  Read the man
> > page
> > and it will explain it to you in detail. Also,
> when you use vmstat be sure
> > to give it an interval (like vmstat 2 10 - this
> means display stats once
> > every 2 seconds for a duration of 10 seconds). 
> The first line returned by
> > vmstat will always be garbage (same with iostat).
> > 
> > HTH 
> > Lisa Koivu 
> > Petite Clumsy Ninja-ette 
> > Ft. Lauderdale, FL, USA 
> > 
> > -Original Message- 
> > Sent:   Monday, June 25, 2001 8:36 AM 
> > To: Multiple recipients of list ORACLE-L 
> > 
> > Listers, 
> > 
> > I am attempting to tune a 7.3.4 OLTP database and
> I have a couple of
> > 
> > questions. 
> > 
> > 1. The db_file_multiblock_count is 64 which seems
> way too high to
> > me. What 
> > are the consequences, if any, of setting this
> parameter too high? 
> > 
> > 2. I want to increase the SGA to be 20% of the
> available memory
> > (currently 
> > about 10%). Once I've made the change how can I
> tell if the Unix machine
> > is 
> > paging memory without a fancy GUI tool? 
> > 
> > Many thanks in advance, 
> > Liam 
> >
>
_
> 
> > Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com
> > <http://www.hotmail.com> . 
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > <http://www.orafaq.com>  
> > -- 
> > Author: Liam Morrin 
> >   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: Smith, Ron L.
> >   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).
> 


==

RE: db_file_multiblock_read_count

[Greg Solomon]

Title: RE: db_file_multiblock_read_count



Hi
 
A year 
or two back, the suggestion (on solaris at least) was to avoid using vmstat with 
the first parm set to a value lower than 10, because the act of measuring perf 
becomes a drain if you do it every 5 seconds (or less).
 
I tend 
to use vmstat 10 10.
 
Cheers
Greg

  -Original Message-From: Mohan, Ross 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, 25 June 2001 
  17:37To: Multiple recipients of list ORACLE-LSubject: 
  RE: db_file_multiblock_read_count
  geez.
   
  Load 
  a trial copy of MKS on NT and get back into da swing of tings, 
  gal!
   
  :)
  
-Original Message-From: Koivu, Lisa 
[mailto:[EMAIL PROTECTED]]Sent: Monday, June 25, 2001 
12:23 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: 
db_file_multiblock_read_count
Thanks Guy.  I don't even have 
a unix system here to do a man page.  Talk about BOREDOM. 
Lis 

  -Original Message- From:   Guy 
  Hammond [SMTP:[EMAIL PROTECTED]] Sent:   Monday, June 
  25, 2001 11:28 AM To: Multiple recipients of list ORACLE-L Subject:        RE: db_file_multiblock_read_count 
  Hi Lisa,   IIRC, 
  the first line of vmstat gives you cumulative values since system boot. 
  And "2 10" means "every 2 seconds, 10 times" (on Solaris, at any 
  rate).
  Cheers,   g   
  
-Original 
Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday, 
June 25, 2001 3:23 PMTo: Multiple recipients of 
    list ORACLE-LSubject: RE: 
db_file_multiblock_read_count
2.  vmstat - look at the 
two columns that start with pg.  Read the man page and it will 
explain it to you in detail. Also, when you use vmstat be sure to give 
it an interval (like vmstat 2 10 - this means display stats once every 2 
seconds for a duration of 10 seconds).  The first line returned by 
vmstat will always be garbage (same with iostat).

OT : UNIX man and Boredom ... RE: db_file_multiblock_read_count

[Deshpande, Kirti]

Lisa,
Who needs a UNIX system for man pages? 
Just try these: 
http://www.rt.com/man/
or 
http://www.bsdi.com/bsdi-man/
or
http://sunsite.queensu.ca/cgi-bin/man-cgi

Hope this ends your BOREDOM ... :) 

Enjoy.. 

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, June 25, 2001 11:23 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: db_file_multiblock_read_count
> 
> Thanks Guy.  I don't even have a unix system here to do a man page.  Talk
> about BOREDOM. 
> 
> Lis 
> 
> -Original Message- 
> From:   Guy Hammond [SMTP:[EMAIL PROTECTED]] 
> Sent:   Monday, June 25, 2001 11:28 AM 
> To: Multiple recipients of list ORACLE-L 
> Subject:RE: db_file_multiblock_read_count 
> 
> Hi Lisa, 
>   
> IIRC, the first line of vmstat gives you cumulative values since system
> boot. And "2 10" means "every 2 seconds, 10 times" (on Solaris, at any
> rate).
> 
>   
> Cheers, 
>   
> g 
>   
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  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).

RE: db_file_multiblock_read_count

[Koivu, Lisa]

Title: RE: db_file_multiblock_read_count





Thanks Guy.  I don't even have a unix system here to do a man page.  Talk about BOREDOM.


Lis


-Original Message-
From:   Guy Hammond [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, June 25, 2001 11:28 AM
To: Multiple recipients of list ORACLE-L
Subject:        RE: db_file_multiblock_read_count


Hi Lisa,
 
IIRC, the first line of vmstat gives you cumulative values since system boot. And "2 10" means "every 2 seconds, 10 times" (on Solaris, at any rate).

 
Cheers,
 
g
 


-Original Message-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 3:23 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: db_file_multiblock_read_count




2.  vmstat - look at the two columns that start with pg.  Read the man page and it will explain it to you in detail. Also, when you use vmstat be sure to give it an interval (like vmstat 2 10 - this means display stats once every 2 seconds for a duration of 10 seconds).  The first line returned by vmstat will always be garbage (same with iostat).

 

RE: db_file_multiblock_read_count

[Mohan, Ross]

Title: RE: db_file_multiblock_read_count



geez.
 
Load a 
trial copy of MKS on NT and get back into da swing of tings, 
gal!
 
:)

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, June 25, 2001 12:23 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  db_file_multiblock_read_count
  Thanks Guy.  I don't even have a 
  unix system here to do a man page.  Talk about BOREDOM. 
  Lis 
  
-Original Message- From:   Guy 
Hammond [SMTP:[EMAIL PROTECTED]] Sent:   Monday, June 25, 
2001 11:28 AM To: Multiple recipients of list ORACLE-L Subject:        RE: db_file_multiblock_read_count 
Hi Lisa,   IIRC, 
the first line of vmstat gives you cumulative values since system boot. And 
"2 10" means "every 2 seconds, 10 times" (on Solaris, at any 
rate).
 Cheers,   g   

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, June 
  25, 2001 3:23 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: db_file_multiblock_read_count
  2.  vmstat - look at the two 
  columns that start with pg.  Read the man page and it will explain it 
  to you in detail. Also, when you use vmstat be sure to give it an interval 
  (like vmstat 2 10 - this means display stats once every 2 seconds for a 
  duration of 10 seconds).  The first line returned by vmstat will 
  always be garbage (same with iostat).
   

RE: db_file_multiblock_read_count/max i/o

[Koivu, Lisa]

Title: RE: db_file_multiblock_read_count/max i/o 





Um   that was something I relied upon my trusty SA to tell me.  
I can't answer that.  Sorry.  Anyone know?  I do know how to determine this is different between platforms.  


Lisa


-Original Message-
From:   Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, June 25, 2001 11:12 AM
To: Multiple recipients of list ORACLE-L
Subject:        RE: db_file_multiblock_read_count


How do you tell for sure what the max i/o size is set to?


-Original Message-
Sent: Monday, June 25, 2001 9:23 AM
To: Multiple recipients of list ORACLE-L




Hi Liam, 


1.  Setting db_file_multiblock_count to a number that when multiplied by
your block size is greater than your max i/o size on your host will
encourage full table scans.  I also read somewhere else about the effects of
doing this, I know there's more to it than what I've stated, but I don't
remember off the top of my head (pre-coffee and post-run this am)


2.  vmstat - look at the two columns that start with pg.  Read the man page
and it will explain it to you in detail. Also, when you use vmstat be sure
to give it an interval (like vmstat 2 10 - this means display stats once
every 2 seconds for a duration of 10 seconds).  The first line returned by
vmstat will always be garbage (same with iostat).


HTH 
Lisa Koivu 
Petite Clumsy Ninja-ette 
Ft. Lauderdale, FL, USA 


    -Original Message- 
Sent:   Monday, June 25, 2001 8:36 AM 
To: Multiple recipients of list ORACLE-L 


    Listers, 


    I am attempting to tune a 7.3.4 OLTP database and I have a couple of


questions. 


    1. The db_file_multiblock_count is 64 which seems way too high to
me. What 
are the consequences, if any, of setting this parameter too high? 


    2. I want to increase the SGA to be 20% of the available memory
(currently 
about 10%). Once I've made the change how can I tell if the Unix machine is 
paging memory without a fancy GUI tool? 


    Many thanks in advance, 
Liam 
_ 
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
<http://www.hotmail.com> . 


    -- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
<http://www.orafaq.com>  
-- 
Author: Liam Morrin 
  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: Smith, Ron L.
  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).

RE: db_file_multiblock_read_count

[Guy Hammond]

Title: RE: db_file_multiblock_read_count



Hi 
Lisa,
 
IIRC, 
the first line of vmstat gives you cumulative values since system boot. And "2 
10" means "every 2 seconds, 10 times" (on Solaris, at any 
rate).
 
Cheers,
 
g
 

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, June 25, 2001 3:23 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  db_file_multiblock_read_count
  2.  vmstat - look at the two 
  columns that start with pg.  Read the man page and it will explain it to 
  you in detail. Also, when you use vmstat be sure to give it an interval (like 
  vmstat 2 10 - this means display stats once every 2 seconds for a duration of 
  10 seconds).  The first line returned by vmstat will always be garbage 
  (same with iostat).
  
 

RE: db_file_multiblock_read_count

[Smith, Ron L.]

How do you tell for sure what the max i/o size is set to?

-Original Message-
Sent: Monday, June 25, 2001 9:23 AM
To: Multiple recipients of list ORACLE-L



Hi Liam, 

1.  Setting db_file_multiblock_count to a number that when multiplied by
your block size is greater than your max i/o size on your host will
encourage full table scans.  I also read somewhere else about the effects of
doing this, I know there's more to it than what I've stated, but I don't
remember off the top of my head (pre-coffee and post-run this am)

2.  vmstat - look at the two columns that start with pg.  Read the man page
and it will explain it to you in detail. Also, when you use vmstat be sure
to give it an interval (like vmstat 2 10 - this means display stats once
every 2 seconds for a duration of 10 seconds).  The first line returned by
vmstat will always be garbage (same with iostat).

HTH 
Lisa Koivu 
Petite Clumsy Ninja-ette 
Ft. Lauderdale, FL, USA 

-Original Message- 
Sent:   Monday, June 25, 2001 8:36 AM 
To: Multiple recipients of list ORACLE-L 

Listers, 

I am attempting to tune a 7.3.4 OLTP database and I have a couple of

questions. 

1. The db_file_multiblock_count is 64 which seems way too high to
me. What 
are the consequences, if any, of setting this parameter too high? 

2. I want to increase the SGA to be 20% of the available memory
(currently 
about 10%). Once I've made the change how can I tell if the Unix machine is 
paging memory without a fancy GUI tool? 

Many thanks in advance, 
Liam 
_ 
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
 . 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Liam Morrin 
  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: Smith, Ron L.
  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).

RE: db_file_multiblock_read_count

[Koivu, Lisa]

Title: RE: db_file_multiblock_read_count





Hi Liam, 


1.  Setting db_file_multiblock_count to a number that when multiplied by your block size is greater than your max i/o size on your host will encourage full table scans.  I also read somewhere else about the effects of doing this, I know there's more to it than what I've stated, but I don't remember off the top of my head (pre-coffee and post-run this am)

2.  vmstat - look at the two columns that start with pg.  Read the man page and it will explain it to you in detail. Also, when you use vmstat be sure to give it an interval (like vmstat 2 10 - this means display stats once every 2 seconds for a duration of 10 seconds).  The first line returned by vmstat will always be garbage (same with iostat).

HTH
Lisa Koivu
Petite Clumsy Ninja-ette
Ft. Lauderdale, FL, USA


-Original Message-
From:   Liam Morrin [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, June 25, 2001 8:36 AM
To: Multiple recipients of list ORACLE-L
Subject:    db_file_multiblock_read_count


Listers,


I am attempting to tune a 7.3.4 OLTP database and I have a couple of 
questions.


1. The db_file_multiblock_count is 64 which seems way too high to me. What 
are the consequences, if any, of setting this parameter too high?


2. I want to increase the SGA to be 20% of the available memory (currently 
about 10%). Once I've made the change how can I tell if the Unix machine is 
paging memory without a fancy GUI tool?


Many thanks in advance,
Liam
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Liam Morrin
  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).