My Oracle Support Banner

SCRIPT - to Set the 'SESSION_CACHED_CURSORS' and 'OPEN_CURSORS' Parameters Based on Usage (Doc ID 208857.1)

Last updated on JULY 10, 2023

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 8.1.6.0 to 8.1.7.4 [Release 8.1.6 to 8.1.7]
Oracle Database - Standard Edition - Version 8.1.6.0 to 8.1.7.4 [Release 8.1.6 to 8.1.7]
Oracle Database - Personal Edition - Version 8.1.6.0 to 8.1.7.4 [Release 8.1.6 to 8.1.7]
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
The below script was validated only for version 8i and below and may not be applicable for version higher than 8i.

Goal

To allow the DBA/Analysts to determine if the sessions cursor cache or open cursors are really a constraint and then increase the parameter session_cached_cursors or open_cursors accordingly.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.