SQL & PL/SQL

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!

impact of open_cursor parameter on performance

533477Sep 18 2006 — edited Sep 18 2006

Dear all,

I would like to know the impact of OPEN_CURSOR parameter value in INIT.ORA
file on the performance.
We are using Oracle 9.2.0.1.0

Description:

In our INIT.ORA file we have set open_cursor = 200

But one of our process is having more than 300 SQL Statements (implicit cursors) and 50 Explicit cursors in it.

So together our process got 350 open_cursor count , which is more than what is there in INIT.ORA file.

Please let me know is there any performance impact by this difference in values.

Please reply as soon as possible

Kind Regads

Vijayaha Kumar

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 16 2006

Added on Sep 18 2006

3 comments

316 views