ORA-00600 [kcbgcur_9] - Instance crashes by SMON
(Doc ID 371198.1)
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 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..
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|