ORA-00600 [QOLHINTPIVADDSID:1] On Insert Into WRH$_SQL_PLAN (Doc ID 1602563.1)

Last updated on FEBRUARY 10, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Alert log reports next error:

ORA-00600: internal error code, arguments: [qolHintPivAddSid:1], [1000], [1000], [], [], [], [], [], [], [], [], []

 
The accompanying trace file show next current sql and call stack functions:

----- Current SQL Statement for this session (sql_id=36z7c4rvtpkw7) -----
INSERT INTO wrh$_sql_plan sp         (snap_id, dbid, sql_id, plan_hash_value, id,          operation, options, object_node, object#, object_owner,          object_name, object_alias, object_type,          optimizer, parent_id, depth, position,          search_columns, cost, cardinality, bytes, other_tag,          partition_start, partition_stop, partition_id, other,          distribution, cpu_cost, io_cost, temp_space,          access_predicates, filter_predicates,          projection, time, qblock_name, remarks, timestamp, other_xml)    SELECT /*+ ordered use_nl(p)               PARAM('_flush_plan_in_awr_sql', 1)               PARAM('_cursor_plan_unparse_enabled', 'FALSE') */           :lah_snap_id lsnid, :dbid dbid,           p.sql_id,           p.plan_hash_value,           p.id,           p.operation,           p.options,           p.object_node,           p.object#,           p.object_owner,           p.object_name,           p.object_alias,           p.object_type,           p.optimizer,           p.parent_id,           p.depth,           p.position,           p.search_columns,           p.cost,           p.cardinality,           p.bytes,           p.other_tag,           p.partition_start,           p.partition_stop,           p.partition_id,           p.other,           p.distribution,           p.cpu_cost,           p.io_cost,           p.temp_space,           NULL access_predicates,           NULL filter_predicates,           NULL projection,           p.time,           p.qblock_name,           p.remarks,           p.timestamp,           p.other_xml      FROM         x$kewrattrnew  atn,         x$kewrtsqlplan spn,         v$sql_plan     p      WHERE  atn.str1_kewrattr     = spn.sqlid_kewrspe         AND atn.num1_kewrattr     = spn.planhash_kewrspe         AND spn.sqlid_kewrspe     = p.sql_id         AND spn.planhash_kewrspe  = p.plan_hash_value         AND spn.childaddr_kewrspe = p.child_address


----- Call Stack Trace -----

... qolHintPivAddSid qolHintUnCompactListArg qolHintUnCompact qolCompactToXml qksxaCompactToCustomXml qksxaCompactToXml xplCompactToOtherXml xplNodeToRow xplMakeRow xplFetchRow...

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms