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: Estimating User Load on the system

RE: Estimating User Load on the system

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Mon, 14 Jul 2003 12:14:10 -0400
Message-Id: <25920.337670@fatcity.com> 





This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.



------=_NextPartTM-000-9b32a5c6-997a-49d2-95df-e9c4cf7776a9
Content-Type: multipart/alternative;


        boundary="----_=_NextPart_001_01C34A22.F58E2AF7"



------_=_NextPart_001_01C34A22.F58E2AF7


Content-Type: text/plain;


        charset="iso-8859-1"



Thanks Dennis,



I have periodic (10 mins) snapshots taken of following views ...



    
  
  1.   gv$session
  
  2.   gv$sesstat
  
  3.   gv$transaction
  
  4.   gv$sess_io
  
  5.   gv$sysstat






Now, I really _can't_ use Statspack, because it tells me overall score. I
need to compute the load put on system by a set list of users ... it is kind
of computation of possible charge back.



So, I have the underlying system stats. but I am having tough time to put
them in perspective for management types. I'd like to show them %CPU usage,
%IO load, %Memory being used ...



any ideas?


Raj






Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !




-----Original Message-----


From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
Sent: Monday, July 14, 2003 12:49 PM


To: Multiple recipients of list ORACLE-L
Subject: RE: Estimating User Load on the system




Raj


   I'll second Jared's idea. Don Burleson in his book Oracle9i
High-Performance Tuning with STATSPACK makes a strong point that looking at
system load must start with the underlying system. Any look at Oracle
performance must begin with an understanding of what the system load was at
that time. As Jared points out, the three components are CPU, I/O, and
memory. For example, you may find that one of these target users is the high
CPU consumer from an Oracle perspective at a point in time. Now, if you
discovered the system CPUs weren't being taxed at that time your conclusions
might be different than if you discovered the system CPUs were pegged at
100% at that time.



Dennis Williams


DBA, 80%OCP, 100% DBA



Lifetouch, Inc.


dwilliams_at_lifetouch.com 



-----Original Message-----


Sent: Monday, July 14, 2003 10:19 AM


To: Multiple recipients of list ORACLE-L





Load on a system is in general comprised of three components:
CPU, memory and IO.



If you have something in place to track those on a per user
basis, then you're doing well.  You might consider also tracking
other users, so that you have a basis for comparison.



Jared



On Monday 14 July 2003 07:04, Jamadagni, Rajendra wrote:


> I have been asked to compute the load put on the system by a 'select group

> of userids'. I know these users and have put something in place where I

> sample periodically following

>

> 1. session stats

> 2. session io

> 3. system stats

> 4. number of sessions

> 5. v$transaction

>

> Am I missing something? Has anyone done this before?  If so, what have you

> computed ?

>

> TIA


> Raj

>





>- ----

> Rajendra dot Jamadagni at nospamespn dot com

> All Views expressed in this email are strictly personal.

> QOTD: Any clod can have facts, having an opinion is an art !



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

------_=_NextPart_001_01C34A22.F58E2AF7
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2654.19">
<TITLE>RE: Estimating User Load on the system</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>Thanks Dennis,</FONT>
</P>

<P><FONT SIZE=3D2>I have periodic (10 mins) snapshots taken of =
following views ...</FONT>
</P>

<P><FONT SIZE=3D2>1. gv$session</FONT>
<BR><FONT SIZE=3D2>2. gv$sesstat</FONT>
<BR><FONT SIZE=3D2>3. gv$transaction</FONT>
<BR><FONT SIZE=3D2>4. gv$sess_io</FONT>
<BR><FONT SIZE=3D2>5. gv$sysstat</FONT>
</P>

<P><FONT SIZE=3D2>Now, I really _can't_ use Statspack, because it tells =
me overall score. I need to compute the load put on system by a set =
list of users ... it is kind of computation of possible charge =
back.</FONT></P>

<P><FONT SIZE=3D2>So, I have the underlying system stats. but I am =
having tough time to put them in perspective for management types. I'd =
like to show them %CPU usage, %IO load, %Memory being used =
...</FONT></P>

<P><FONT SIZE=3D2>any ideas?</FONT>
<BR><FONT SIZE=3D2>Raj</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-----------------</FONT>
<BR><FONT SIZE=3D2>Rajendra dot Jamadagni at nospamespn dot com</FONT>
<BR><FONT SIZE=3D2>All Views expressed in this email are strictly =
personal.</FONT>
<BR><FONT SIZE=3D2>QOTD: Any clod can have facts, having an opinion is =
an art !</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: DENNIS WILLIAMS [<A =
HREF=3D"mailto:DWILLIAMS_at_LIFETOUCH.COM">mailto:DWILLIAMS_at_LIFETOUCH.COM</=
A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Monday, July 14, 2003 12:49 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: RE: Estimating User Load on the =
system</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Raj</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp; I'll second Jared's idea. Don Burleson =
in his book Oracle9i</FONT>
<BR><FONT SIZE=3D2>High-Performance Tuning with STATSPACK makes a =
strong point that looking at</FONT>
<BR><FONT SIZE=3D2>system load must start with the underlying system. =
Any look at Oracle</FONT>
<BR><FONT SIZE=3D2>performance must begin with an understanding of what =
the system load was at</FONT>
<BR><FONT SIZE=3D2>that time. As Jared points out, the three components =
are CPU, I/O, and</FONT>
<BR><FONT SIZE=3D2>memory. For example, you may find that one of these =
target users is the high</FONT>
<BR><FONT SIZE=3D2>CPU consumer from an Oracle perspective at a point =
in time. Now, if you</FONT>
<BR><FONT SIZE=3D2>discovered the system CPUs weren't being taxed at =
that time your conclusions</FONT>
<BR><FONT SIZE=3D2>might be different than if you discovered the system =
CPUs were pegged at</FONT>
<BR><FONT SIZE=3D2>100% at that time.</FONT>
</P>

<P><FONT SIZE=3D2>Dennis Williams</FONT>
<BR><FONT SIZE=3D2>DBA, 80%OCP, 100% DBA</FONT>
<BR><FONT SIZE=3D2>Lifetouch, Inc.</FONT>
<BR><FONT SIZE=3D2>dwilliams_at_lifetouch.com </FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>Sent: Monday, July 14, 2003 10:19 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
</P>
<BR>
<BR>

<P><FONT SIZE=3D2>Load on a system is in general comprised of three =
components:</FONT>
<BR><FONT SIZE=3D2>CPU, memory and IO.</FONT>
</P>

<P><FONT SIZE=3D2>If you have something in place to track those on a =
per user</FONT>
<BR><FONT SIZE=3D2>basis, then you're doing well.&nbsp; You might =
consider also tracking</FONT>
<BR><FONT SIZE=3D2>other users, so that you have a basis for =
comparison.</FONT>
</P>

<P><FONT SIZE=3D2>Jared</FONT>
</P>

<P><FONT SIZE=3D2>On Monday 14 July 2003 07:04, Jamadagni, Rajendra =
wrote:</FONT>
<BR><FONT SIZE=3D2>&gt; I have been asked to compute the load put on =
the system by a 'select group</FONT>
<BR><FONT SIZE=3D2>&gt; of userids'. I know these users and have put =
something in place where I</FONT>
<BR><FONT SIZE=3D2>&gt; sample periodically following</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; 1. session stats</FONT>
<BR><FONT SIZE=3D2>&gt; 2. session io</FONT>
<BR><FONT SIZE=3D2>&gt; 3. system stats</FONT>
<BR><FONT SIZE=3D2>&gt; 4. number of sessions</FONT>
<BR><FONT SIZE=3D2>&gt; 5. v$transaction</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; Am I missing something? Has anyone done this =
before?&nbsp; If so, what have you</FONT>
<BR><FONT SIZE=3D2>&gt; computed ?</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; TIA</FONT>
<BR><FONT SIZE=3D2>&gt; Raj</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
------------</FONT>
<BR><FONT SIZE=3D2>&gt;- ----</FONT>
<BR><FONT SIZE=3D2>&gt; Rajendra dot Jamadagni at nospamespn dot =
com</FONT>
<BR><FONT SIZE=3D2>&gt; All Views expressed in this email are strictly =
personal.</FONT>
<BR><FONT SIZE=3D2>&gt; QOTD: Any clod can have facts, having an =
opinion is an art !</FONT>
</P>

<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.net" =
TARGET=3D"_blank">http://www.orafaq.net</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Jared Still</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: jkstill_at_cybcon.com</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- =
858-538-5051 <A HREF=3D"http://www.fatcity.com" =
TARGET=3D"_blank">http://www.fatcity.com</A></FONT>
<BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Mailing list =
and web hosting services</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
------</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from).&nbsp; You may</FONT>
<BR><FONT SIZE=3D2>also send the HELP command for other information =
(like subscribing).</FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.net" =
TARGET=3D"_blank">http://www.orafaq.net</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: DENNIS WILLIAMS</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: DWILLIAMS_at_LIFETOUCH.COM</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- =
858-538-5051 <A HREF=3D"http://www.fatcity.com" =
TARGET=3D"_blank">http://www.fatcity.com</A></FONT>
<BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Mailing list =
and web hosting services</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
------</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from).&nbsp; You may</FONT>
<BR><FONT SIZE=3D2>also send the HELP command for other information =
(like subscribing).</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C34A22.F58E2AF7--


------=_NextPartTM-000-9b32a5c6-997a-49d2-95df-e9c4cf7776a9
Content-Type: text/plain;
	name="ESPN_Disclaimer.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
	filename="ESPN_Disclaimer.txt"

*********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************1


Received on Mon Jul 14 2003 - 11:14:10 CDT












Original text of this message













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