OPEN_CURSORS parameter

From: Dipen Kotecha <dkotecha_at_ford.invalid>
Date: Fri, 10 Sep 1999 11:26:34 +0200
Message-ID: <37D8CECA.F084F6B7@ford.invalid>

I am trying to tune our database (7.3.4) and have been told that (amongst other things) increasing the parameter 'open_cursors' should help. Before I do so I would like to be sure that I understand what I am doing and whether it is the right thing to do.

I understand that this parameter represents the max. number of cursors that a session can have open, but is this the same type of cursor as a PL/SQL cursor? Also if a session has more cursors open will it use more CPU, memory, i/o as a result?

Currently it is set to 50 and I am thinking of changing it to 100. Any advice/information is greatly appreciated.

Thanks in advance,

Dipen Received on Fri Sep 10 1999 - 04:26:34 CDT