Need help understanding a column in v$undostat
sape007Apr 28 2004 — edited Aug 24 2007Version: 9.2.0.4.0, Solaris
Undo type: AUTO
Undo size: 600 MB
UNDO_RETENTION = 900 (15 min)
When I do
select * from v$undostat
Column name: NOSPACEERRCNT
The thing I dont understand is that: when I get non-zero rows for that column does it mean that users got error since No Free undo space available?
Issue is NO development users (of DB) complained with any error when the NOSPACEERRCNT had non-zero value?
--- Oracle notes ---
NOSPACEERRCNT (NUMBER)
Identifies the number of times space was requested in the undo tablespace and there was no free space available. That is, all of the space in the undo tablespace was in use by active transactions. The corrective action is to add more space to the undo tablespace.