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 FEBRUARY 03, 2019
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
- Running AWR reports after upgrade to 10.2.0.4 from 10.2.0.2 returns intermittent errors
select undotsn, sum(undoblks)/1000 undob,sum(txncount) txcnt, max(maxquerylen)....
where dbid = :dbid
and instance_number = :inst_num
and end_time > :b_eitvtime
and begin_time < :e_eitvtime
group by undotsn;
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
- STACK TRACE:
Applied the 10.2.0.4.0 Patchset
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document