Re: above average CPU usage

Ravi wrote:
> Hi,
>
> I have 10g RAC - 2 node cluster. Most of the time the CPU usage range from 50-
> 60%. Found that using ADDM, some of the queries took most resource. But when
> I check from sql*plus the response was quicker and the explain plan output
> was also not bad.
>
> Please give me your valuable inputs to troubleshoot.
>
> Thanks.

I think the ADDM terrific when used appropriately.

ADDM makes recommendations. Synapses must be applied when determining whether the recommendation applies to the current system.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org