You may be find that Luca Canali's script is useful for your analysis. Review service activity section. https://canali.web.cern.ch/canali/docs/article_metalink_on_AWR.htm Cheers Riyaj Shamsudeen Principal DBA, Ora!nternals - http://www.orainternals.com - Specialists in Performance, RAC and EBS Blog: http://orainternals.wordpress.com/ Oracle ACE Director and OakTable member <http://www.oaktable.com/> Co-author of the books: Expert Oracle Practices <http://tinyurl.com/book-expert-oracle-practices/>, Pro Oracle SQL, <http://tinyurl.com/ahpvms8> <http://tinyurl.com/ahpvms8>Expert RAC Practices 12c. <http://tinyurl.com/expert-rac-12c> Expert PL/SQL practices <http://tinyurl.com/book-expert-plsql-practices> <http://tinyurl.com/book-expert-plsql-practices> On Tue, Mar 31, 2015 at 9:53 AM, Krishna K <krishna.setwin@xxxxxxxxx> wrote: > Hi Guys, > > I have a question regarding CPU consumption for RAC services. > My environment is RAC 8 node cluster. I have a service which is running on > 4 nodes. we have nearly 60+ services on all 8 nodes. > I want to get CPU consumed by 1 service for the past 7 days. can anybody > point me in right direction? > > Thanks in advance. > krishna >
