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
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?