ORA-06502 in AWR Report after upgrade to 10.2.0.4,Error encountered in Undo Segment Summary. (Doc ID 781878.1)

Last updated on NOVEMBER 14, 2016

Applies to:

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

Symptoms

Error encountered in Undo Segment Summary while executing SQL statement: Len = 834

select undotsn, sum(undoblks)/1000 undob,sum(txncount) txcnt, max(maxquerylen)....

from dba_hist_undostat
where dbid = :dbid
and instance_number = :inst_num
and end_time > :b_eitvtime
and begin_time < :e_eitvtime
group by undotsn;

Encountered error:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ksedst <- ksedmp <- ksddoa <- ksdpec <- ksfpec <- kgerev <- kgerec1 <- peirve <- pfricdrve <- pisoch

 

Changes

Applied the 10.2.0.4.0 Patchset

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