Re: above average CPU usage

After one more round of thorough check, came to understand that there might be a I/O usage. Because system wide waits like db_file_sequential_read, db_file_scattered_read, read_by_other_session, direct_path_read_temp
are shown to be with high values in v$system_event . This might cause CPU usage high.

How about your opinion on this ?

Mark D Powell wrote:
>> > Hi,
>>
>[quoted text clipped - 15 lines]
>>
>> Matthias
>
>I do not use ADDM due to licensing requirements for the performance
>pack, but from what I am told by people who have used it, ADDM leaves
>a lot to be desired.
>
>Matthias's questions about making sure you are doing an apples to
>apples comparison are valid. If you have replaced any bind variables
>with constants in your query or made any change whatsoever then the
>plan comparison is not valid.
>
>HTH -- Mark D Powell --

-- 
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/oracle/200708/1