Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: High CPU usage

Re: High CPU usage

From: Valentin Minzatu <valentinminzatu_at_yahoo.com>
Date: 13 Oct 2006 13:48:59 -0700
Message-ID: <1160772539.265971.121510@h48g2000cwc.googlegroups.com> 





CURSOR_SHARING is a dynamic parameter. If altering it did not provide
any improvement your problem is not related to the use of literals.
Post an AWR report in order to receive further help.



BTW flushing the shared pool had adverse effects as it forced *all* the
queries to be hard re-parsed - not the best idea for an overloaded
system.



Cheers,


Valentin
Received on Fri Oct 13 2006 - 15:48:59 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US