Oracle database SESSION_CACHED_CURSORS Recommendation for Siebel (Doc ID 534165.1)

Last updated on MAY 04, 2016

Applies to:

Siebel System Software - Version 7.7.2 [18325] and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 7.7.2 [18325] and later
Database: Oracle 9.2.0.6 and later
Application Server OS: Microsoft Windows 2003 Server
Database Server OS: Microsoft Windows 2000 Server SP 2

This document was previously published as Siebel SR 38-3390362511.

***********Checked for Relevance on 02-OCT-2014*********
***********Checked for Relevance on 05-MAY-2016*********

Symptoms

Hello,

Our Siebel Sales 7.7.2.3 implementation is running on Oracle 9.2.0.6.
We have just received an ORA-600 error which our DBA is recommending to be eliminated by removing the "session_cached_cursors" parameter from the init.ora file.
Our current setting for this Oracle parameter is 25.
Will removing this parameter from the init.ora file have any negative impact on performance?

Thanks!

Cause

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 hundreds of Community platforms