| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Billing cpu usage on a monthly basis
Hans
I just returned from vacation and thought I'd fallen into the Twilight Zone and returned to the glory days of time-sharing. My experience is that you are talking real money here and be sure whatever you build, make it bulletproof. It sounds as if you're already on the right track by considering the consequences of aborted sessions.
You could use the underlying O.S. usage statistics for this. However, if you use a single instance installed as the "oracle" username, then nearly all of the resource usage will be tagged to that username, rather than your customer usernames. One way around that obstacle would be to create a separate instance for each customer and have Oracle installed separately for each customer.
That is about as profound as I can get on a Friday just returned from vacation.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Wednesday, July 09, 2003 3:04 AM
To: Multiple recipients of list ORACLE-L
Hi,
We're planning to consolidate a large amount of our production databases into one database. Our customers will be charged based on their use of the central machine's resources (other suggestions are very welcome). I saw a method of keeping track of resource usage, by means of the auditing mechanisms in Oracle: - build a system trigger which recognises logon and logoff.
I assume that'll work just fine. However, I'm not sure how to charge our customer for aborted sessions.
Any suggestions are very welcome.
HTH,
Hans de Git
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hans de Git
INET: hansdegit_at_hotmail.com
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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). Received on Fri Jul 11 2003 - 10:54:24 CDT
 |
 |