| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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 <FONT
face="Comic Sans MS" size=2>Oracle DBA <FONT face="Comic Sans MS"
size=2>Fuelspot
<FONT face=Tahoma
size=2>-----Original Message-----From: Koivu, Lisa
[mailto:lisa.koivu_at_efairfield.com]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. <FONT face=Arial
color=#0000ff size=2>I can't answer that. Sorry. Anyone
know? I do know how to determine this is different between
platforms.
Lisa
-----Original Message----- <FONT
face=Arial size=1>From: <FONT face=Arial
size=1>Smith, Ron L. [SMTP:rlsmith_at_kmg.com] <FONT face=Arial
size=1>Sent: Monday, June 25,
size=1>To: <FONT face=Arial
size=1>Multiple recipients of list ORACLE-L <FONT face=Arial
size=1>Subject: <FONT
face=Arial size=1>RE: db_file_multiblock_read_count
How do you tell for sure what the max i/o size is
set to?
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 <FONT
face=Arial size=2>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 <FONT
face=Arial size=2>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 <FONT face=Arial
size=2>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 <FONT face=Arial
size=2>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 <FONT
face=Arial size=2>Ft. Lauderdale, FL, USA
<FONT face=Arial
size=2>-----Original Message----- <FONT face=Arial
size=2>Sent: Monday, June 25, 2001 8:36 AM <FONT
face=Arial size=2>To: Multiple recipients of list
ORACLE-L
Many
thanks in advance, Liam <FONT
face=Arial
size=2>_________________________________________________________________________
Get Your Private, Free E-mail from MSN
Hotmail at <A target=_blank
href="http://www.hotmail.com">http://www.hotmail.com <FONT
face=Arial size=2><<A target=_blank
href="http://www.hotmail.com">http://www.hotmail.com> .
Fat City Network Services --
(858) 538-5051 FAX: (858) 538-5051 <FONT face=Arial
size=2>San Diego, California --
Public Internet access / Mailing Lists <FONT face=Arial
size=2>--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send
an E-Mail message to:
 |
 |