Re: CPU consumption for single RAC service

On Tue, Mar 31, 2015 at 2:28 PM Riyaj Shamsudeen <riyaj.shamsudeen_at_gmail.com> wrote:

> 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