open cursor

[m2001331]

Hi,

I would like to know what is the impact of increasing the value of open cursors in parameter file?
what if the increased value is still not enough? is there are maximum limit to open cursors? if there is what is it?
i understand that the value specified for the open cursor in the parameter file applies to per session rather than the entire database.
please advise.
thanks.

 

[Turkbear]

Hi,
The major impact will be on memory usage..allocate too many cursors and memory segment swapping may start resulting in greatly decreased performance..

Changes to the parameter should be based on problems with the current settings and be inceremental in nature..You can have too much of a good thing...