This tablespace is in my case 8GB. I'm on oracle 10g and got critical warning:
Tablespace usage critical: UNDOTBS (96%)
I also executed this command:
select sum (bytes/1048576) MB
FROM
DBA_SEGMENTS
WHERE
tablespace_name = 'UNDOTBS' ;
It gives me 7625,625MB.
Could I extend this tablespace with this command:
ALTER TABLESPACE "UNDOTBS" ADD DATAFILE '/path/to/ts.db' SIZE 4194304000;
Can I do it on running system and wont I destroy anything?