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.
[EMAIL PROTECTED]
-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
_
MSN Zoeken, voor duidelijke zoekresultaten! http://search.msn.nl
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hans de Git
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
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).
