Ora-600 [15160] Joining Dba_objects and Dba_segments

In this Document
Symptoms
Cause
Solution
References

Applies to:

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;

The stack trace shows:

ksedmp kgeriv kgesiv ksesic0 kkogfp kkooqb kkoqbc apakkoqb apaqbd ...

This error can also be raised when you join some other DBA_ views, like

joining DBA_TYPES and DBA_OBJECTS.

Cause

The cause of this problem has been identified in Bug 4648181. It is fixed in 11.1 rel.

The error is generated when two union-all views inner-joined to each other.

Solution

To implement the solution, please execute the following steps:

1. Check if there's for 10.1 or 10.2 for your platform available in Metalink.

2. Use the workaround:

alter session set "_optimizer_push_pred_cost_based"=FALSE;

References

Errors

Keywords