Select On V$LOGMNR_CONTENTS Fails With ORA-600 [Krvxread001] (Doc ID 1462889.1)

Last updated on FEBRUARY 07, 2014

Applies to:

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

Symptoms

Failing query:

SELECT SCN, TO_CHAR(SCN) AS SCN_CHAR, SCN AS SCN_FLOAT, NVL(:aucEolSCN - SCN, :aucEolSCN) AS SCN_EOF_DIFF, TO_CHAR(TIMESTAMP) AS TIMESTAMP, TO_CHAR(XIDUSN || '.' || XIDSLT || '.' || XIDSQN) AS TRANID, SEG_OWNER, SEG_NAME, USERNAME, ROLLBACK, OPERATION_CODE, SQL_REDO, SQL_UNDO, CSF, STATUS FROM V$LOGMNR_CONTENTS;

 


Alert log:

LOGMINER: End mining logfile for session -2147483391 thread 2 sequence 394, +PVT1_ARCHIVELOG_DG/pvt1/archivelog/2012_04_06/thread_2_seq_394.528.779872219
LOGMINER: Begin mining logfile for session -2147483391 thread 2 sequence 395, +PVT1_ARCHIVELOG_DG/pvt1/archivelog/2012_04_06/thread_2_seq_395.529.779872225
LOGMINER: End mining logfile for session -2147483391 thread 2 sequence 395, +PVT1_ARCHIVELOG_DG/pvt1/archivelog/2012_04_06/thread_2_seq_395.529.779872225
LOGMINER: Begin mining logfile for session -2147483391 thread 2 sequence 396, +PVT1_ARCHIVELOG_DG/pvt1/archivelog/2012_04_06/thread_2_seq_396.530.779873953
LOGMINER: End mining logfile for session -2147483391 thread 2 sequence 396, +PVT1_ARCHIVELOG_DG/pvt1/archivelog/2012_04_06/thread_2_seq_396.530.779873953
LOGMINER: thread 2 disabled
ORA-00600: internal error code, arguments: [krvxread001], [2], [], [], [], [], [], [], [], [], [], []

 

Call stack:

krvxread krvxgtsp_GetTxnSingleProcess krvxgtf krvxgt krvfcact2

 

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