To set the SQL cache size, set the new DBParm variable SQLCache to a value that is less than the maximum number of cursors that can be opened on the client. To determine this number, use the following formula.

SQLCache = n

where nis <= open_cursors - 5 - declare_cursor_space

 

Variable	Value
open_cursors	The server setting for the number of cursors that a process may have open.
5	The number of reserved cursors. Five cursors should be reserved for use by the PowerBuilder Oracle interface.
declare_cursor_space	The maximum number of cursors that you expect to open from within the PowerBuilder environment per connection.

According to the Oracle documentation, in Oracle 6 and 7 there is a server setting (OPEN_CURSORS) that specifies the maximum number of open cursors a single process can have at one time. The default value is 50 in both Oracle 6 and Oracle 7. In Oracle 6, the range is described as being between 5 and 255. In Oracle 7, the range is described as being between 1 and the operating system limit.