RE: How to calculate user load on the system

From: Aponte, Tony <AponteT_at_hsn.net>
Date: Wed, 16 Jan 2002 15:45:19 -0800
Message-ID: <F001.003F2171.20020116151524@fatcity.com>

Then
you're in luck.  I'd recommend starting with Oracle Response Time Analysis from www.orapub.com.  Although it won't give you exactly what you need, it will help you get to the next step.  Once you understand a session's response time components, it's a short hop to figuring out the V$SESSTAT statistics that make up the CPU time, physical/logical I/O operations and memory footprint. <SPAN
class=573381023-16012002> 
<SPAN
class=573381023-16012002>HTH
<SPAN
class=573381023-16012002>Tony

<FONT face="Times New Roman"

  size=2>-----Original Message-----From: Jamadagni, Rajendra   [mailto:Rajendra.Jamadagni_at_espn.com]Sent: Wednesday, January 16,   2002 5:54 PMTo: Aponte, Tony;
  ORACLE-L_at_fatcity.comSubject: RE: How to calculate user load on the   system
<SPAN

  class=584095322-16012002>Database Load ... is the main target at this time   ...
<SPAN

  class=584095322-16012002> 
<SPAN

  class=584095322-16012002>Thanks Tony,
<SPAN

  class=584095322-16012002> 
<SPAN

  class=584095322-16012002>Raj
<SPAN

  class=584095322-16012002><FONT face="Courier New"

  size=2>______________________________________________________

  Rajendra
  Jamadagni     
          MIS, ESPN Inc.
  Rajendra dot Jamadagni at ESPN
  dot com
  Any opinion expressed here is
  personal and doesn't reflect that of ESPN Inc.   QOTD: Any clod can have facts,
  but having an opinion is an
  art!   

    <FONT face=Tahoma
    size=2>-----Original Message-----From: Aponte, Tony     [mailto:AponteT_at_hsn.net]Sent: Wednesday, January 16, 2002 5:53     PMTo: ORACLE-L_at_fatcity.comCc:
    Rajendra.Jamadagni_at_espn.comSubject: RE: How to calculate user     load on the system
    Raj, sorry for me being confused.  Are you trying to     measure what the application executable is doing outside the database (i.e..     host system load) or the activity inside the database (i.e.. per     user/program/module DB stats)?
    Tony
      Received on Wed Jan 16 2002 - 17:45:19 CST