Re: CPU consumption for single RAC service

From: Riyaj Shamsudeen <riyaj.shamsudeen_at_gmail.com>
Date: Tue, 31 Mar 2015 10:33:20 -0700
Message-ID: <CAA2DszwhzxeBp-mJAxGUBb5UzhGWm2wagRmOK=hEBX+Je+6tLw_at_mail.gmail.com>



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_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 31 2015 - 19:33:20 CEST

Original text of this message