Friday, October 03, 2014

Bug 5497611

I used Oracle Enterprise Manager to look at the execution plan for some SQL in an Oracle database. (The SQL shown is just an example done later for the purposes of this blog post. As usual, click on the image to enlarge it and bring it into focus if necessary.):

This produced the following ORA-00600 message several times in the alert log:
Wed Oct  1 18:13:21 2014
Errors in file /oracle/app/oracle/product/10.2.0/admin/mrmdpt1/udump/mrmdpt1_ora_15467.trc:
ORA-00600: internal error code, arguments: [qctVCO:csform], [0], [0], [0], [0], [112], [2], [224]
I looked in the trace file and saw the SQL which had caused the problem:
ORA-00600: internal error code, arguments: [qctVCO:csform], [0], [0], [0], [0], [112], [2], [224]
Current SQL statement for this session:
SELECT extractvalue(xmlval, '/*/info[@type = "sql_profile"]'), extractvalue(xmlval, '/*/info[@type = "outline"]'), extractvalue(xmlval, '/*/info[@type = "dyn
amic_sampling"]'), nvl(extractvalue(xmlval, '/*/info[@type = "index_size"]'), -1) from (select xmltype(other_xml) xmlval from v$sql_plan where sql_id = :1 an
d other_xml is not null and id = 1)

I extracted the SQL and ran it in a SQL*Plus session:

SQL> set head off
SQL> l
  2  extractvalue(xmlval, '/*/info[@type = "sql_profile"]'),
  3  extractvalue(xmlval, '/*/info[@type = "outline"]'),
  4  extractvalue(xmlval, '/*/info[@type = "dynamic_sampling"]'),
  5  nvl(extractvalue(xmlval, '/*/info[@type = "index_size"]'), -1)
  6  from
  7  (select xmltype(other_xml) xmlval
  8   from v$sql_plan
  9   where sql_id = 'cp5caasd2udnw'
 10   and other_xml is not null
 11*  and id = 1)
SQL> /
Each time I did this, a similar ORA-00600 appeared in the alert log, proving that I had correctly diagnosed the cause of the problem. I looked the problem up in My Oracle Support and found that it was caused by bug 5497611.

1 comment:

  1. Anonymous7:42 pm

    A 16 year old bug .. time to upgrade..