| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: db_file_multiblock_read_count
<SPAN
class=573193316-25062001>Hi
<SPAN
class=573193316-25062001>
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).
<SPAN
class=573193316-25062001>
I tend
to use vmstat 10 10.
<SPAN
class=573193316-25062001>
<SPAN
class=573193316-25062001>Cheers
<SPAN
class=573193316-25062001>Greg
<FONT face=Tahoma
size=2>-----Original Message-----From: Mohan, Ross
[mailto:MohanR_at_STARS-SMI.com]Sent: Monday, 25 June 2001
17:37To: Multiple recipients of list ORACLE-LSubject:
RE: db_file_multiblock_read_count
<FONT color=#0000ff face=Arial
size=2>geez.
<FONT color=#0000ff face=Arial
size=2>
Load
a trial copy of MKS on NT and get back into da swing of tings,
gal!
<FONT color=#0000ff face=Arial
size=2>
<FONT color=#0000ff face=Arial
size=2>:)
<FONT face=Tahoma
size=2>-----Original Message-----From: Koivu, Lisa
[mailto:lisa.koivu_at_efairfield.com]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----- <FONT
face=Arial size=1>From: Guy
Hammond [SMTP:guy.hammond_at_avt.co.uk] <FONT face=Arial
size=1>Sent: Monday, June
25, 2001 11:28 AM <FONT face=Arial
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
Hi Lisa, <FONT
face=Arial> 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).
<FONT color=#0000ff face=Tahoma
size=2>Cheers, <FONT
color=#0000ff face=Tahoma size=2>g <FONT color=#0000ff
face=Tahoma size=2>
-----Original
Message-----From:<FONT
face=Tahoma size=2> Koivu, Lisa [<A
href="mailto:lisa.koivu_at_efairfield.com">mailto:lisa.koivu_at_efairfield.com]<FONT
face=Tahoma size=2>Sent: Monday,
June 25, 2001 3:23 PM<FONT face=Tahoma
size=2>To: Multiple recipients of
list ORACLE-L<FONT face=Tahoma
size=2>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).
<FONT
![]() |
![]() |