Hi,
I got ora-30036 while doing a transaction in database.
The undo tablespace was full.
My undo management is set to AUTO.
SQL> sho parameter undo
NAME TYPE VALUE
------------------------------------ ----------- -----------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
My issue is that the status in DBA_UNDO_EXTENTS does not seem to change even after a sufficiently long time.
SQL> SELECT STATUS, SUM(BYTES)/(1024*1024) Size_MB, COUNT(*)
FROM DBA_UNDO_EXTENTS GROUP BY STATUS;
STATUS SIZE_MB COUNT(*)
--------- ---------- ----------
UNEXPIRED 1.25 20
EXPIRED 3 48
ACTIVE 1955.625 591
What am I possibly missing? Thanks.