.............

[@more@]Subject: Ora-600 [15160] Joining Dba_objects and Dba_segments
Doc ID: Note:351092.1 Type: PROBLEM
Last Revision Date: 14-AUG-2006 Status: PUBLISHED
In this Document
Symptoms
Cause
Solution
References
Applies to:
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;
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 Patch 4648181 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
Bug 4648181 - Ora-600 [15160] Joining Dba_Objects And Dba_Segments
Errors
ORA-600 [15160]
Keywords
'DBA_SEGMENTS'

ITPub博客

Ora-600 [15160] Joining Dba_objects and Dba_segments

Applies to:

Symptoms

Cause

Solution

References

Errors

Keywords

最新文章

Subject:	Ora-600 [15160] Joining Dba_objects and Dba_segments
	Doc ID:	Note:351092.1	Type:	PROBLEM
	Last Revision Date:	14-AUG-2006	Status:	PUBLISHED