Re: High CPU usage

shiva wrote:
> I did set CURSOR_SHARING to SIMILAR this morning and it doesn't seem
> like it is giving any relief. I made this change dynamically and then
> flushed shared_pool. waiting for more then 5 hours and cpu utilization
> is still same. Do I need to reboot the database for this parameter to
> take effect?

Shooting blindly in the dark rarely results in a target being hit.

There is nothing wrong with high CPU usage in and of itself.

What problem?
With what version?
Determined by what means?

-- 
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