Active Undo segments not decreasing
Dear Friends,
Our Undo segments got full and we started getting error message "ORA-30036: unable to extend segment by 4 in undo tablespace 'UNDOTBS1'"
I increased the tablespace and it is working now but the Active Undo segments are not decreasing, please see below:
SQL> SELECT DISTINCT STATUS, SUM(BYTES)/1024/1024,COUNT(*) FROM DBA_UNDO_EXTENTS GROUP BY STATUS;
STATUS SUM(BYTES)/1024/1024 COUNT(*)
--------- -------------------- ----------
UNEXPIRED 22321.8125 6972
EXPIRED 1204.3125 354
ACTIVE 324855.563 27359
I checked the running sqls and some DMLs queries are running but this Active status in increasing with every minute.
Please let me know how to control this.
We are on Oracle 11g/Linux.
Thanks.