ORA-00600 [kkdcicf2] when running Query against View: flashback_transaction_query. (Doc ID 1433663.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.

Symptoms

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

----- Current SQL Statement for this session (sql_id=bgapvthm690vd) -----
select *
from flashback_transaction_query f,
   (select versions_xid from flash versions
    between scn 2097654 and 2097665) v
where f.xid=v.versions_xid

 

----- Incident Context Dump -----
...
Error: ORA-600 [kkdcicf2] [] [] [] [] [] [] []
...
[08]: kkdcicf []<-- Signaling
[09]: kkqstijpr [SQL_Transform]
[10]: kkqstpfe [SQL_Transform]
[11]: kkqstacu [SQL_Transform]
[12]: kkqstcrf [SQL_Transform]
[13]: kkqstrtedrv [SQL_Transform]
[14]: qksqbApplyToQbcLoc []
[15]: qksqbApplyToQbc []
[16]: kkqdrv [SQL_Transform]

 

Changes

 

Sequence of events leading to the problem

- Determine current SCN (SCN_1)
- Create a small transaction such as "insert into table ...".
- Determine the updated SCN (SCN_2)
- Run a query against flashback_transaction_query.
  Use versions_xid pseudo column and BETWEEN SCN clause.

  See: test case.

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