billing cpu usage of a monthly basis

Hi,

We're planning to consolidate a large amount of our production database 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:
- drop the sys.aud$ table

• create a new audit table in another schema
• provide sys with a synonym or view for that newly created aud$
• build a 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 Received on Tue Jul 08 2003 - 09:33:46 CDT