IM InfoSphere Identity Insight, Version 8.0

Sizing the Oracle Statement Cache

Oracle database administrators must appropriately size their statement cache.

About this task
The product can be very statement intensive, which means that the Oracle statement cache can grow very quickly and exceed the default Oracle database settings. For more information about sizing and tuning these parameters, see your Oracle documentation.
Configure the following parameters at the server level using the ALTER SYSTEM SET Oracle command:
SESSION_CACHED_CURSORS
A good value for this parameter is about 20 simultaneous cursors per pipeline or parallel processing pipeline thread.
OPEN_CURSORS
A good value for this parameter is about 20 simultaneous cursors per pipeline or parallel processing pipeline thread.
CURSOR_SHARING
This parameter greatly affects performance. Configure this parameter based on the fact that the product widely uses bind variables, and the application will benefit from cursor sharing


Feedback

Last updated: 2009