Re: billing cpu usage of a monthly basis

On Tue, 8 Jul 2003 16:33:46 +0200, Hans de Git wrote (in message <72383d4a.0307080633.e065a27_at_posting.google.com>):

> 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

Hi Hans,

I am not sure if this kind of billing is smart to introduce here. There are quite some fluctuations between oracle server versions running the same applications. Some queries could easily use double cpu, otheres less than in older versions. How would you cope with that ? Besides that, if you are paid for cpu usage, you'd better quit tuning the apps ... ;-)

-- 
met vriendelijke groeten,
Ronald
http://ronr.nl/unix-dba