session_cached_cursors pros & cons

Hello List,

Does any one have any problems with setting session_cahced_cursors to 100 in 9.2.0.5 Oracle DB? I came across many people, rather I would say tuning experts, telling to set this parameter = 10. Why does it default value is set to 0 rather than any postive value? Please share your experience in this regards.

Best Regards,
Syed Jaffar Hussain

Visit us on www.alfransi.com.sa
====== Banque Saudi Fransi - Privacy Notice ======
This message is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any use of this information by persons or entities other than the intended recipient is prohibited. If you have received this in error, please contact the sender and delete the material from your computer. Any opinions and other information contained in this message that do not relate to the official business of Banque Saudi Fransi shall be understood as neither given or endorsed by it. Although precautions have been taken to ensure no viruses are present in this email, BSF cannot accept responsibility for any loss or damage arising from the use of this email or attachments.
====== Banque Saudi Fransi - Privacy Notice ======

--
http://www.freelists.org/webpage/oracle-l