Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: db_file_multiblock_read_count

RE: db_file_multiblock_read_count

From: Greg Solomon <greg.solomon_at_betfair.com>
Date: Mon, 25 Jun 2001 09:47:11 -0700
Message-ID: <F001.00336C64.20010625094050@fatcity.com>

<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 

face=Arial> Received on Mon Jun 25 2001 - 11:47:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US