Re: CPU consumption for single RAC service

From: Riyaj Shamsudeen <riyaj.shamsudeen_at_gmail.com>
Date: Tue, 31 Mar 2015 12:28:17 -0700
Message-ID: <CAA2Dszx_DEZmBKevE=4KE78_=gQv_zuz8XQtfMLtoo2xGXXSLQ_at_mail.gmail.com>

Hello Krishna,
  dba_hist_service_stat is based upon v$service_stats dynamic view. 'DB CPU' is one of the statistics available in v$service_stats view. So, you should be able to calculate the amount of CPU consumed by the service using the 'DB CPU' statistics.

HTH 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 12:01 PM, Krishna K <krishna.setwin_at_gmail.com> wrote:

> Thanks Riyaj.
>
> How can i convert service activity to physical CPU consumed on a node?
>
> On Tue, Mar 31, 2015 at 12:33 PM Riyaj Shamsudeen <
> riyaj.shamsudeen_at_gmail.com> wrote:
>
>> 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 - 21:28:17 CEST