Re: SESSION_CACHED_CURSORS

Hi

you might want to have a look at these ML notes

Note:396940.1
Note:270097.1
Note:274496.1

Thanks

--
LSC




On 8/30/07, DBA Deepak <oracle.tutorials_at_gmail.com> wrote:


>

> 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