Setting the Cache in Oracle
\The Sandbox \PB History & Future \New in PB 4 \DB Enhancements \Cache in Oracle
Array Fetches
in Oracle 7
Bind Variables
Cached
Statements
Select & DB
Painters
Remote Procedure
Informix
ODBC
Oracle 7
Peformance
Gains
Cache in
Oracle
SQL Server
System 10
Watcom 4.0

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. 

PBL Peeper PB Help PB History
& Future About Us Feedback Site Map

Google
 
Web www.techno-kitten.com
www.sybase.com