Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Open Cursors and Database Performance Issue

GQApr 5 2011 — edited Apr 5 2011

Dear All,

I have Oracle 11g on MS Windows 2008 Enterprise Edition of 64-bit. I have in my init file *.open_cursors=3000 and *._spin_count=2000. I have 32GB RAM on the production server. Application used too many open cursors and that number goes up to 2900 even. Does this amount of open cursors introduces performamnce issues of the database.

How many maximum cursors I should define what is ._spin_count parameter? Any suggestion regarding this to increase DB performance.

This

Locked Post

New comments cannot be posted to this locked post.

Locked on May 3 2011

Added on Apr 5 2011

#general-database-discussions

6 comments

607 views