EMERGENCY Undo tablespace grew, disk(1/12) 97% full
Hello,
I have an Oracle server with disk 90% full. We will soon move to new storage this month, but now undo tablespace seems grew, eat up disk to 97% on 1 of 12 SAN disks(/data001) as below. Other 11 disks are ok until storage migration. What I look for now is how can I lock up so that there's no issue when undo tablespace tries to eat up 100% of the disk.
I was not paying attention to what the old size was,but currently, the undotbs01.dbf is 24G.
-rw-r----- 1 orasvc01 dba 18M Feb 8 09:41 cont_GMESTNP_01.ctl -rw-r----- 1 orasvc01 dba 1.1G Feb 8 09:41 redo_GMESTNP_01a.rdo -rw-r----- 1 orasvc01 dba 1.1G Feb 8 09:36 redo_GMESTNP_03b.rdo -rw-r----- 1 orasvc01 dba 2.1G Feb 8 09:38 sysaux01.dbf -rw-r----- 1 orasvc01 dba 24G Feb 8 09:41 undotbs01.dbf
Tagged:
0