oracle 10.2.0.2.0的一個BUG

SELECT * FROM v$version

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
PL/SQL Release 10.2.0.2.0 - Production
CORE 10.2.0.2.0 Production
TNS for Linux: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production
5 rows selected.

執行如下SQL以system使用者：

SELECT table_name, column_name, s.segment_name, CHUNK, PCTVERSION, CACHE,
LOGGING, in_row, s.tablespace_name, initial_extent, next_extent,
min_extents, pct_increase, max_extents, FREELISTS, freelist_groups,
BUFFER_POOL, FREEPOOLS, RETENTION
FROM SYS.dba_segments s, SYS.dba_lobs l
WHERE l.owner = s.owner
AND l.owner = :own
AND l.segment_name = s.segment_name
AND s.segment_type = 'LOBSEGMENT'

出現如下錯誤：

ORA-00600: internal error code,arguments:[15160]

查詢發現：

CAUSE DETERMINATION
====================
This is a known problem
The base bug is
BUG 4648181 10.1.0.4 ORA-600 [15160] JOINING DBA_OBJECTS AND DBA_SEGMENTS

執行如下命令後，可以正常執行：

alter session set "_optimizer_cost_based_transformation"=off;