Re: billing cpu usage of a monthly basis

"Ronald Rood" <devnull_at_ronr.nl> wrote in message news:0001HW.BB30E36600014575F0284600_at_news.cis.dfn.de...
> 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
>
>

I would love to be in this business. Can you hook me up? Received on Tue Jul 08 2003 - 18:45:54 CDT