SELECT o.owner, o.object_type, o.status, COUNT(*) object_count, SUM(s.EXTENTS) SumExt, SUM (s.bytes)/1024/1024 SumMB FROM dba_objects o,dba_segments s WHERE o.owner = s.owner AND o.object_name = s.segment_name AND o.object_type = s.segment_type AND o.subobject_name = s.partition_name GROUP BY o.owner, o.object_type, o.status;
Subject:
Ora-600 [15160] Joining Dba_objects and Dba_segments
Oracle Server - Enterprise Edition - Version: 10.1 to 10.2 This problem can occur on any platform.
Symptoms
The following internal error is reported:
ORA-600 [15160] JOINING DBA_OBJECTS AND DBA_SEGMENTS
Current SQL statement for this session is: SELECT o.owner, o.object_type, o.status, COUNT(*) object_count, SUM(s.extents) SumExt, SUM (s.bytes)/1024/1024 SumMB FROM dba_objects o,dba_segments s WHERE o.owner = s.owner AND o.object_name = s.segment_name AND o.object_type = s.segment_type AND o.subobject_name = s.partition_name GROUP BY o.owner, o.object_type, o.status;