Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
SMON crashes the instance on startup with ORA-600 [kcbgcur_9]
You shall get into this issue in following scenario.
o A rollback segment is dropped.
o It belongs to locally managed tablespace.
o The rollback segment is marked as temporary for later cleanup.
1. The following query is to check if it is a Locally Managed tablespace.
SELECT EXTENT_MANAGEMENT FROM DBA_TABLESPACES WHERE TABLESPACE_NAME='&RBS';
--- Extent Management of the RBS tablespace is LOCAL
--- RBS = Rollback Segment tablespace
2. The following query will show the segments that are marked as TEMPORARY in the rollback segment tablespace.
SELECT SEGMENT_NAME, SEGMENT_TYPE FROM DBA_SEGMENTS WHERE SEGMENT_TYPE='TEMPORARY'
--- Returns TEMPORARY object / objects..
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms