ORA-600  While SMON is Doing Temporary Segment Drop
Last updated on OCTOBER 19, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 9.2 to 12.1]
Information in this document applies to any platform.
Checked for relevance on 01-Nov-2010
When starting the database after a crash or for normal maintenance after a truncate table, the error below will occur 100 times and then the instance will crash.
The errors are caused because SMON is trying to clean a temp segment in a tablespace by looking at the bitmap index in the tablespace. The bitmap index is corrupted and this causes SMON to fail when trying to clean up the segment.
From the alert.log:
ORA-00600: internal error code, arguments: , , , , , , , 
Non-fatal internal error happenned while SMON was doing temporary segment drop.
SMON encountered 53 out of maximum 100 non-fatal internal errors.
The issue occurred after a table was truncated with drop storage option.
Current SQL statement for this session:
TRUNCATE TABLE SCOTT.ABC_DEF_1001_RESOURCE_TRANS DROP STORAGE
Another possible error which can be encountered is:
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