ANBOB™

ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [VOPRVL1], [], [], [], [], [], [], [] Issues

一朋友在db 10.2.0.2 版本在insert 时触犯了ora-600 VOPRVL1, 查询是bug，这里记录一下。
sql 样式伪代码

insert into table
with t as (
select xx from tablexx
)
from t join xx on xx;

Bug 9221639 – Dumps/OERI on Query with Subquery Factoring (WITH clause) and Object View (Doc ID 9221639.8)

Bug 9221639  Dumps/OERI on Query with Subquery Factoring (WITH clause) and Object View
This note gives a brief overview of bug 9221639.
The content was last updated on: 28-JUN-2013
Click here for details of each of the sections below.
Affects:
Product (Component)    Oracle Server (Rdbms)
Range of versions believed to be affected     Versions BELOW 12.1
Versions confirmed as being affected             11.2.0.1        11.1.0.7        11.1.0.6        10.2.0.5        10.2.0.4
Platforms affected    Generic (all / most platforms affected)
Fixed:

This issue is fixed in
12.1.0.1 (Base Release)
11.2.0.2 (Server Patch Set)
Symptoms:

PROBLEM:
--------
Select count(*) from View Failing with the following internel error.
ORA-600: internal error code, arguments: [voprvl1], [], [], [], [], [], [], []

DIAGNOSTIC ANALYSIS:
--------------------
Tried setting OFE to 8.1.7,9.2.0 but still we are getitng the ora-600 error.
Tried the testcase on 11.1.0.7 & 11.2.0 still the query is failing.

10.2.0.4
========
SQL> select count(*) from test_v;
select count(*) from test_v
*
ERROR at line 1:
ORA-600: internal error code, arguments: [voprvl1], [], [], [], [], [], [],[]

11.1.0.7
========
SQL> select count(*) from test_v;
select count(*) from test_v
*
ERROR at line 1:
ORA-600: internal error code, arguments: [kkqvmrvl1], [], [], [], [], [], [],[], [], [], [], []

11.2.0
======
SQL> select count(*) from test_v;
select count(*) from test_v
*
ERROR at line 1:
ORA-600: internal error code, arguments: [kkqvmRmViewFromLst1], [], [], [],[], [], [], [], [], [], [], []

WORKAROUND:
-----------
None

RELATED BUGS:
-------------

REPRODUCIBILITY:
----------------
Able to Reproduce the issue inhouse on 10.2.0.4

TEST CASE:
----------

STACK TRACE:
------------
ksedmp: internal or fatal error
ORA-600: internal error code, arguments: [voprvl1], [], [], [], [], [], [],
[]
Current SQL statement for this session:
select count(*) from test_v
----- Call Stack Trace -----
calling              call     entry                
 location             type     point                 
-------------------- -------- -------------------- -
ksedmp()+744         CALL     ksedst()          
kgerinv()+200        PTR_CALL 0000000000000000     
kgeasnmierr()+28     CALL     kgerinv() 
voprvl()+164         CALL     kgeasnmierr() 

other know issues:
Bug 5363258 Query rewrite can fail with OERI[voprvl1]

打赏

微信扫一扫，打赏作者吧～