ORA-600 [15160]已知的bug记录

ORA-600 [15160]

版本：7.0 以上

描述:在复杂的连接操作的时候找不到合适的表作为开始点，报出这个错误。和优化器相关的bug，可用采用禁用优化器的相关参数来避免错误


  Known Issues:

NB

Bug

Fixed

Description

 

 

13906168

11.2.0.4, 12.1.0.1

Assorted Internal Errors during optimization due to corrupt statistics

V11020001 V11020002 V11020003 CORR OERI

 

11925954

11.2.0.3, 12.1.0.1

Internal errors with join predicate push-down bewtween two inner-joined UNION ALL views.

V11010006 V11010007 V11020001 V11020002 CBO OERI

 

11839377

11.2.0.3, 12.1.0.1

flashback table fails with internal errors [15160] / [kkoipt:invalid aptyp]

V11020001 V11020002 FLASHBACK OERI

 

10198126

11.2.0.3, 12.1.0.1

ORA-600 [15160] / ORA-600 [kkoipt:invalid aptyp] / dump [kkogbro] from DBMS_STATS on IOT

V11010006 V11010007 V11020001 V11020002 CBO DBMSPKG DUMP IOT OERI

 

9832338

11.2.0.3, 12.1.0.1

ORA-600 [15160] / ORA-7445 [kkogfp] from CONNECT BY and OUTER JOIN (+)

V11020001 V11020002 CB203 CBO CONNECTBY DUMP ERROR OERI

 

9736229

11.2.0.2, 12.1.0.1

ORA-600 [15160] for query with left outer join and XMLTable

V11020001 ANSI OERI XDB

 

9698523

11.2.0.2, 12.1.0.1

ORA-600[15160] message not explicit enough

V11020001 DIAG ENH OERI

 

9663844

11.2.0.2, 12.1.0.1

OERI [15160] from star transformation query

V10020002 V10020003 V10020004 V10020005 V11010006 V11010007 V11020001 CBO OERI STAR/TEMP

 

9491655

11.2.0.2, 12.1.0.1

OERI [15160] on query with multiple views

V11010006 V11010007 V11020001 CBO OERI

 

9466188

11.2.0.2, 12.1.0.1

OERI[15160] with fix for bug 9303766

V11020001 CBO OERI

 

9280935

11.2.0.2, 12.1.0.1

ORA-600 [15160] due to table elimination

V11010006 V11010007 V11020001 CBO OERI

 

9258615

11.2.0.2, 12.1.0.1

Dump on kkoiqb or OERI:15160 when DISTINCT view is outer joined using constant

V10010005 V10020002 V10020003 V10020004 V10020005 V11010006 V11010007 V11020001 DUMP OERI

 

8947490

11.2.0.2, 12.1.0.1

OERI[15160] using SQL tuning advisor for full outer joined UNION

V11010006 V11010007 V11020001 ANSI DBMSPKG OERI

 

8782089

11.2.0.2, 12.1.0.1

OERI [15160] on ANSI join

V10020002 V10020003 V10020004 V10020005 V11010006 V11010007 V11020001 ANSI CBO OERI

 

8518100

10.2.0.5, 11.2.0.2, 12.1.0.1

OERI [15160] with 6626018 enabled

V10020002 V10020003 V10020004 V11010006 V11010007 V11020001 CBO OERI

 

9831544

11.2.0.2

ORA-600 [15160] / ORA-600 [kkogfp:no start table] from JPPD

V11010006 V11010007 V11020001 CBO OERI

 

7687980

11.2.0.1

Wrong Results / ORA-600 with SEMI/ANTI join and Join Elimination

V10020002 V10020003 V10020004 V10020005 V11010006 V11010007 CBO OERI WRONGRES

 

8295719

11.2.0.1

ORA-600 [15160] running query with FULL OUTER join

V11010006 V11010007 ANSI CBO OERI

 

8287492

11.2.0.1

ORA-600 [15160] on insert with _optimizer_null_aware_antijoin=true

V11010006 V11010007 CBO OERI

 

7370515

11.2.0.1

ORA-600[15160] from UNION / UNION ALL in anti join

V11010006 V11010007 CBO OERI

 

7370410

10.2.0.5, 11.2.0.1

ORA-600 [15160] from star transformation with JPPD

V10020002 V10020003 V10020004 V11010006 V11010007 CBO OERI STAR/TEMP

 

7319436

11.2.0.1

Wrong results from JPPD push predicate into outer joined GROUP BY view

V11010006 V11010007 CBO ERROR OERI WRONGRES

 

7257160

10.2.0.5, 11.2.0.1

OERI:15160 from star transformation

V10020002 V10020003 V10020004 V11010006 V11010007 OERI STAR

 

7031622

10.2.0.5, 11.2.0.1

Spin on kkojnp / ORA-600 [15160] with Star transformation

V10020002 V10020003 V10020004 V11010006 V11010007 CPU ERROR HANG/SPIN LEAK/MEM OERI PARSEPERF STAR

 

6016087

10.2.0.4, 11.1.0.7, 11.2.0.1

OERI[15160] from subquery unnesting

V10020002 V10020003 V11010006 CBO OERI

 

5652086

10.2.0.4, 11.2.0.1

OERI[15160] from ANSI join

V10020002 V10020003 V11010006 V11010007 ANSI OERI

 

5694466

10.2.0.4, 11.1.0.6

OERI[15160] from subquery unnesting

V10020002 V10020003 CBO OERI

 

5476507

10.2.0.4, 11.1.0.6

OERI[15868] / OERI[15160] can occur with cursor sharing

V10020002 V10020003 LITREPL OERI

 

5172444

10.2.0.3, 11.1.0.6

Wrong Results/OERI[15160] on complex query with joinback elimination

V10020002 OERI STAR WRONGRES

 

5043097

9.2.0.8, 10.2.0.3, 11.1.0.6

OERI [15160] during query optimization

V10010005 V10020002 CBO OERI

 

4712638

9.2.0.8, 10.2.0.4, 11.1.0.6

OERI[15160] / dump [kkogbro]

V10010005 V10020002 V10020003 CBO DUMP OERI

 

4648181

10.2.0.3, 11.1.0.6

OERI [15160] possible from pushed predicates

V10010005 V10020002 CBO OERI RA104 REGRESSION

 

4450399

9.2.0.8, 10.2.0.2

OERI:15160 during joinback elimination of 1-row tables in star transformation

V10010005 OERI R9206 RA104 RA201 REGRESSION STAR

 

4020449

9.2.0.7, 10.1.0.5, 10.2.0.1

Wrong results or OERI[15160] from star transformation

OERI STAR/TEMP WRONGRES

 

3938376

9.2.0.7, 10.1.0.4, 10.2.0.1

OERI[15160] accessing via a bitmap join index

BITMAP OERI

 

3481959

10.1.0.4, 10.2.0.1

SQLX query using ROWNUM fails with OERI [15160]

V09020008 OERI XDB

 

3332598

9.2.0.8, 10.1.0.2

OERI 15160 with OPTIMIZER_MODE=FIRST_ROWS_10

CBO OERI

 

3142337

9.2.0.8, 10.1.0.2

OERI[15160] during optimization

CBO OERI

 

1946566

8.1.7.3, 9.2.0.1

OERI:15160 possible from join of 5 or more table when CBO attempts STAR

CBO OERI STAR

 

1844768

9.0.1.4, 9.2.0.1

TABLE function with left correlations plus an OUTER join signals OERI:15160

ERROR OBJECT OERI

 

2285638

9.0.1.0

OERI:15160 from semi join

CBO OERI

 

1478965

8.1.7.3, 9.0.1.0

OERI:15160 possible with EXISTS/IN and HASH or MERGE ALWAYS_SEMI_JOIN

ERROR OERI

 

551901

7.3.4.3, 8.0.4.0

Dump (SIGFPE) caused by table with 0 rows under CBO

CBO DUMP OERI