Message-Id: <26007.339460@fatcity.com> From: "Jamadagni, Rajendra" Date: Thu, 24 Jul 2003 12:06:24 -0400 Subject: Computing resource consumption 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 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 ---------------------------------------------------------------------------- ---- 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 Computing resource consumption

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