Re: billing cpu usage of a monthly basis

Hi,

Instead of calculating each session CPU time, you can use Resource Manager to see the amount of CPU consumed by a group of users. This suppose that you can assign each user connected to the db, to a group.

The followwing query gives the CPU consumed by the defined groups:

select 	name, active_sessions, consumed_cpu_time 
from 	v$rsrc_consumer_group;

Dias

hansdegit_at_hotmail.com (Hans de Git) wrote in message news:<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
Received on Wed Jul 09 2003 - 15:41:28 CDT