ORA-600: [kkslrpl1], [8] [ID 987963.1][@more@]
Information in this document applies to any platform.
This is identical to bug:6704409 which is a duplicate of unpublished base bug 3597294.
IMPACT
------
Non-critical issue.
No data corruption.
WORKAROUND
In this Document
Symptoms
Changes
Cause
Solution
References
Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 9.2.0.8 - Release: 9.2 to 9.2Information in this document applies to any platform.
Symptoms
Alert log reports ORA-600 [kkslrpl1] when literal replacement (cursor_sharing ) is being used.ALERT LOG
---------
Errors in file oracle/admin/testdb/udump/testdb_ora_4659.trc:
ORA-00600: internal error code, arguments: [kkslrpl1], [8], [], [], [], [], [], []
TRACE FILE
----------
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kkslrpl1], [8], [], [], [], [], [], []
No current SQL statement being executed.
Call Stack Trace
~~~~~~~~~~~~~~~~
kkslrpl kkspsc0 opiosq0 kpooprx kpoal8 ...
Changes
Cursor Sharing is enable by using one of the following parameters:- CURSOR_SHARING = SIMILAR
- CURSOR_SHARING = FORCE
FORCE
Forces statements that may differ in some literals, but are otherwise identical, to share a cursor, unless the literals affect the meaning of the statement.
SIMILAR
Causes statements that may differ in some literals, but are otherwise identical, to share a cursor, unless the literals affect either the meaning of the statement or the degree to which the plan is optimized.
Forces statements that may differ in some literals, but are otherwise identical, to share a cursor, unless the literals affect the meaning of the statement.
SIMILAR
Causes statements that may differ in some literals, but are otherwise identical, to share a cursor, unless the literals affect either the meaning of the statement or the degree to which the plan is optimized.
Cause
During literal replacement (cursor_sharing) we have exceeded the maximum number of digits allowed for the bind variable number.This is identical to bug:6704409 which is a duplicate of unpublished base bug 3597294.
IMPACT
------
Non-critical issue.
No data corruption.
Solution
FIXIssue fix in RDBMS release 10.2 onward.
WORKAROUND
Use cursor_sharing=exactPATCH
For some platforms there are patches available. See Patch:3597294 .
Note: Starting with July 2008 no more *new* fixes will be provided based on 9.2. except a customer would purchase Extended Support.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28227905/viewspace-1060400/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28227905/viewspace-1060400/