Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SESSION_CACHED_CURSORS and Form

Davide PSep 14 2022

Hi,
Forms and bad development uses many session_cached_cursors.
Is not possible to use bind, so I've this values:
PARAMETER VALUE USAGE
session_cached_cursors 300 32167%
session_cached_cursors 300 32167%

As per note 2091529.1
it's recommended to use up to 500 and not more.
What's performance impact if I set session_cached_cursors to 3000?

Thank you

Added on Sep 14 2022

#general-database-discussions

4 comments

203 views