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: Computing resource consumption

RE: Computing resource consumption

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Thu, 24 Jul 2003 23:27:39 -0500
Message-Id: <26007.339502@fatcity.com> 





This is a multi-part message in MIME format.



------=_NextPart_000_0001_01C3523B.3039AC60
Content-Type: text/plain;


        charset="us-ascii"


Content-Transfer-Encoding: quoted-printable



Raj,



=20



A pretty common (and actually pretty accurate) chargeback unit is the =
LIO.



You can get this information by using the standard AUDIT CONNECT =
feature,


and using the LREAD value as your basis. If you wanted to get fancy, you
might also charge by the parse call (which you're already collecting in =
your


V$SESSTAT query). The reason I'd focus on these two metrics is because =
these


are the two operations on an Oracle system that absolutely prevent the
system from scaling.



=20



You could count physical I/Os as well, but that would be redundant if =
you're


already catching LIO call counts.



=20



Cary Millsap


Hotsos Enterprises, Ltd.


http://www.hotsos.com



Upcoming events:


- Hotsos Clinic <http://www.hotsos.com/training/clinic101>  101 in =

Denver,


Sydney


- Hotsos Symposium 2004 <http://www.hotsos.com/events/symposium/2004>  =

March


7-10 Dallas


- Visit www.hotsos.com for schedule details...




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


From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On Behalf Of
Jamadagni, Rajendra


Sent: Thursday, July 24, 2003 12:04 PM


To: Multiple recipients of list ORACLE-L
Subject: Computing resource consumption



=20



Does anyone know any papers or techniques to compute resource =
consumption by


users in a DB systems? This may or may not be for computing charge-back =
to


the client, but my questions are=20



    
  
  1.   What do you compute?=20
  
  2.   are there any standard methods and or standard formula?=20






I am collecting v$sesstat when a session exits, but is data alone from
session stats sufficient? How about the work done by background =
processes on


user's behalf?=20



Do you do anything like this at your workplace? This is something that =
might


be coming down the line, so I have been asked to start looking for =
related


stuff.



Thanks in advance=20


Raj=20

-------------------------------------------------------------------------=



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


------=_NextPart_000_0001_01C3523B.3039AC60
Content-Type: text/html;
	charset="us-ascii"
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=3Dus-ascii">


<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">
<title>Computing resource consumption</title>

<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Times;
	panose-1:2 2 6 3 5 4 5 2 3 4;}
@font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
h2
	{margin-top:12.0pt;
	margin-right:0in;
	margin-bottom:3.0pt;
	margin-left:0in;
	page-break-after:avoid;
	font-size:12.0pt;
	font-family:Arial;
	color:#333333;
	font-weight:bold;}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
p
	{margin-right:0in;
	margin-left:0in;
	font-size:12.0pt;
	font-family:"Times New Roman";}
p.SidebarBody, li.SidebarBody, div.SidebarBody
	{margin-top:4.0pt;
	margin-right:.25in;
	margin-bottom:4.0pt;
	margin-left:.25in;
	text-align:justify;
	line-height:12.0pt;
	border:none;
	padding:0in;
	font-size:10.0pt;
	font-family:Times;
	color:teal;}
p.Body, li.Body, div.Body
	{margin-top:0in;
	margin-right:0in;
	margin-bottom:6.0pt;
	margin-left:0in;
	font-size:9.0pt;
	font-family:Arial;}
p.sidebarbody0, li.sidebarbody0, div.sidebarbody0
	{margin-top:4.0pt;
	margin-right:.25in;
	margin-bottom:4.0pt;
	margin-left:.25in;
	text-align:justify;
	line-height:12.0pt;
	font-size:10.0pt;
	font-family:Times;
	color:teal;}
p.body0, li.body0, div.body0
	{margin-top:0in;
	margin-right:0in;
	margin-bottom:6.0pt;
	margin-left:0in;
	font-size:9.0pt;
	font-family:Arial;}
span.emailstyle20
	{font-family:Arial;
	color:navy;}
span.EmailStyle23
	{font-family:Arial;
	color:navy;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Raj,</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>A pretty common (and actually =
pretty
accurate) chargeback unit is the LIO. You can get this information by =
using the
standard AUDIT CONNECT feature, and using the LREAD value as your basis. =
If you
wanted to get fancy, you might also charge by the parse call (which
you&#8217;re already collecting in your V$SESSTAT query). The reason =
I&#8217;d
focus on these two metrics is because these are the two operations on an =
Oracle
system that absolutely prevent the system from =
scaling.</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>You could count physical I/Os as =
well, but
that would be redundant if you&#8217;re already catching LIO call =
counts.</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<div>

<p><b><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;color:navy;font-weight:bold'>Cary =
Millsap</span></font></b><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:navy'><br>
Hotsos Enterprises, Ltd.<br>
<a href=3D"http://www.hotsos.com">http://www.hotsos.com</a><br>
<br>
Upcoming events:<br>


- <a href=3D"http://www.hotsos.com/training/clinic101">Hotsos =

Clinic&nbsp;101</a>
in Denver, Sydney<br>


- <a href=3D"http://www.hotsos.com/events/symposium/2004">Hotsos =

Symposium 2004</a>
March 7&#8211;10 Dallas<br>


- Visit <a href=3D"http://www.hotsos.com">www.hotsos.com</a> for =

schedule
details...</span></font></p>

</div>

<p class=3DMsoNormal><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma'>-----Original Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> =
ml-errors_at_fatcity.com
[mailto:ml-errors_at_fatcity.com] <b><span style=3D'font-weight:bold'>On =
Behalf Of </span></b>Jamadagni,
Rajendra<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Thursday, July 24, =
2003
12:04 PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> Multiple recipients =
of list
ORACLE-L<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> Computing =
resource
consumption</span></font></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;</span></font></p>

<p><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New"'>Does anyone know any papers or techniques to compute =
resource
consumption by users in a DB systems? This may or may not be for =
computing
charge-back to the client, but my questions are </span></font></p>

<p><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New"'>1. What do you compute?</span></font> <br>
<font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>2.
are there any standard methods and or standard formula?</span></font> =
</p>

<p><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New"'>I am collecting v$sesstat when a session exits, but is =
data
alone from session stats sufficient? How about the work done by =
background
processes on user's behalf? </span></font></p>

<p><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New"'>Do you do anything like this at your workplace? This is
something that might be coming down the line, so I have been asked to =
start
looking for related stuff.</span></font></p>

<p><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New"'>Thanks in advance</span></font> <br>
<font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>Raj</span></font>
<br>
<font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'>-------------------------------------------------------------------=
-------------</span></font>
<br>
<font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>Rajendra
dot Jamadagni at nospamespn dot com</span></font> <br>
<font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>All
Views expressed in this email are strictly personal.</span></font> <br>


Received on Thu Jul 24 2003 - 23:27:39 CDT












Original text of this message













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