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
![]() |
![]() |