Message-Id: <26007.339502@fatcity.com> From: "Cary Millsap" Date: Thu, 24 Jul 2003 23:27:39 -0500 Subject: RE: Computing resource consumption 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 101 in = Denver, Sydney - Hotsos Symposium 2004 = March 7-10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- From: ml-errors@fatcity.com [mailto:ml-errors@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 Computing resource consumption

Raj,

 

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.

 

You could count physical I/Os as = well, but that would be redundant if you’re already catching LIO call = counts.

 

Cary = Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos = Clinic 101 in Denver, Sydney
- Hotsos = Symposium 2004 March 7–10 Dallas
- Visit www.hotsos.com for = schedule details...

-----Original Message-----
From: = ml-errors@fatcity.com [mailto:ml-errors@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

 

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.