Re: auditing CPU usage

From: De DBA <dedba_at_tpg.com.au>
Date: Wed, 9 Mar 2016 22:07:58 +1000
Message-ID: <56E0121E.4090403_at_tpg.com.au>



Yes, business unit, department, cost centre.. The problem is of course that the users log on via middleware. It is a proxy logon to the database, so that we can identify the users, but the middleware can't (won't) connect to different services... that would be too easy ;-)

Cheers,
Tony

On 08/03/16 21:30, Sayan Malakshinov wrote:
> Hi Tony,
>
> What does "business unit" mean? Is it something like department?
> In that case you can create several services (one per each "business unit"), so you can find statistics in these views: v$service_event, v$servicemetric, v$service_stats.
>
> Also you can enable statistics gathering with dbms_monitor.serv_mod_act_stat_enable (v$serv_mod_act_stats)
>
> On Tue, Mar 8, 2016 at 2:17 PM, De DBA <dedba_at_tpg.com.au <mailto:dedba_at_tpg.com.au>> wrote:
>
> G'day.
>
> Today I got a question out of left field that made me think of the good old days when we used to rent computing time on the main frame per processor cycle. Management would like to have a break-down of used processor cycles (they really said that) per business unit.
>
> I don't think the database can do that. There is cpu time in ASH, but that's only a sample per second, and it's ephemeral. Hardly useful for charge-back. The AWR copy of ASH is even worse - only part of ASH gets flushed to the AWR. There is no guarantee that the captured part even gives a representative picture of what each individual session used.. There used to be OS auditing tools for this purpose, but they cannot audit individual user sessions within the database, I guess.
>
> Has anyone had this put to them? What did you come up with?
>
> Cheers,
> Tony
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>
> --
> Best regards,
> Sayan Malakshinov
> Oracle performance tuning engineer
> Oracle ACE Associate
> http://orasql.org

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 09 2016 - 13:07:58 CET

Original text of this message