Statement Caching for Oracle 10g
\The Sandbox \PB History & Future \New in PB 11 \New in PB 11.1 \Oracle 10g Stmt Caching
Vista support
Incremental
Rebuild
RadControls
OrcaScript
Enhancements
Pipelines in
Windows Forms
Web Services
from Web Forms
RTL DatePicker
& MonthCalendar
RTE Page
Display Properties
Null Values as
Retrieval Args
Informix 10 Support
Oracle 10g
Stmt Caching
ASE15
Identity Columns

Statement caching in Oracle 10g provides and manages a cache of statements for each session. On the server, cursors are ready to be used without the need to parse the statement again before execution. Statement caching can be used with connection pooling and improves performance and scalability.

To set the maximum size of the statement cache, set the StatementCache DBParm to the number of statements you want to cache. The default value is 0, which means that statement caching is disabled in the current session. This DBParm is available only in the O10 database interface.

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

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