the customer $100 per user per CPU or $10,000 per CPU for unlimited number
of users. That will bring the prices to the same level charged by some very successful software companies. You are bound to stay competitive.
On 2003.07.25 01:24, Cary Millsap wrote:
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 <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----- Jamadagni, Rajendra Sent: Thursday, July 24, 2003 12:04 PM To: Multiple recipients of list ORACLE-L
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 !
-- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
