Database ORA-600 / ORA-7445 Analysis , Diagnostic Repository (ADR) & Packaging (MOSC)

MOSC Banner

ORA-600: internal error code, arguments: [kdsgrp1]

Hello,

An error 600 occurs often since one day. In the incident files, always:

row 0x04c36a96.3 continuation at: 0x04c36a96.3 file# 19 block# 223894 slot 3 not found (dscnt: 0)

The request : SELECT segment_type, owner, segment_name FROM dba_extents WHERE file_id = 19 AND 223894 BETWEEN block_id AND block_id+blocks-1;

--> A partitioned table (partition name found because the file_id is the one's of a datafile in a partitioned tablespace)

I didn't find clearly what to do with this type of error. Analyze the table? Rebuild indexes (i don't think so)? Create a new partition like the other ones, drop the old partition, rename the partition the partition ...

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center