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

Home -> Community -> Mailing Lists -> Oracle-L -> SESSION_CACHED_CURSORS

SESSION_CACHED_CURSORS

From: DBA Deepak <oracle.tutorials_at_gmail.com>
Date: Thu, 30 Aug 2007 23:11:32 +0530
Message-ID: <75aa80160708301041u205c958bo3bad5618a78f7049@mail.gmail.com> 





Hi All,


Have a doubt on the SESSION_CACHED_CURSORS parameter. If we set this
parameter to some higher value is there a chance that the shared pool will
get fragmented because of this parameter setting? If yes, then am just
curious to know how?



Some articles say if we have a fragmented shared pool then we may consider
decreasing this parameter value. In this case why Oracle will not be able to
free-up the memory occupied by the cached cursors when space is required in
the shared pool for incoming SQLs.



-- 



Regards,



Deepak


Oracle DBA



--



http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 30 2007 - 12:41:32 CDT












Original text of this message













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