Database Administration (MOSC)

MOSC Banner

ORA-600 [17059] error

edited Dec 12, 2010 3:04AM in Database Administration (MOSC) 7 commentsAnswered
 The application has generated ORA-600 [17059] error in 9.2.0.7 database. I looked up in Metalink for this particular error. Looks like the number of child cursors against a single parent object has reached 32768. I can verify this in the trace file too. The solution in the metalink doc suggest that i should increase the limit to 65536. How can i increase the child cursor limit? The other initialization parameter related to cursors are: CURSOR_SHARING=exact
CURSOR_SPACE_FOR_TIME=false
OPEN_CURSORS=500
SESSION_CACHED_CURSORS=0

Thanks in advance,
MLRR

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center