Have you looked at the Chargeback app in EM12c/13c?
Pete
Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA
Phone: +61262924095 | | Mobile: +61414443449
Email: pete.sharman@xxxxxxxxxx Twitter: @SharmanPete LinkedIn:
au.linkedin.com/in/petesharman
Website: petewhodidnottweet.com
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not, it's much harder than that!"
Bruce Pihlamae, long term Oracle DBA
-----Original Message-----
From: De DBA [mailto:dedba@xxxxxxxxxx] ;
Sent: Tuesday, March 8, 2016 10:17 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: auditing CPU usage
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l