Computing resource consumption

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Thu, 24 Jul 2003 12:06:24 -0400
Message-Id: <26007.339460@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-7b42e6e3-1d11-45c0-b6c7-d31f7ba1b21b Content-Type: multipart/alternative;

boundary="----_=_NextPart_001_01C351FD.87AB6BC0"

------_=_NextPart_001_01C351FD.87AB6BC0
Content-Type: text/plain;

charset="iso-8859-1"

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

What do you compute?
are there any standard methods and or standard formula?

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?

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
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 !

------_=_NextPart_001_01C351FD.87AB6BC0
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.45">
<TITLE>Computing resource consumption</TITLE>
</HEAD>
<BODY>

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

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


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? =


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
 Raj
 <FONT SIZE=3D2 FACE=3D"Courier =

New">-------------------------------------------------------------------=

-------------
 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 !


</BODY>
</HTML>

------_=_NextPart_001_01C351FD.87AB6BC0--

------=_NextPartTM-000-7b42e6e3-1d11-45c0-b6c7-d31f7ba1b21b 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.*********************************************************************2

Received on Thu Jul 24 2003 - 11:06:24 CDT