-- 1.undotbs1 datafile 크기조회
select file_name, TABLESPACE_NAME, bytes/1024/1024 from dba_data_files where tablespace_name = 'UNDOTBS1';
-- 2.undotb1 datafile 크기 2배로 변경 및 확인
alter database datafile '/u01/app/oracle/oradata/ORCL/undotbs01.dbf' resize 680m;
select file_name, TABLESPACE_NAME, bytes/1024/1024 from dba_data_files where tablespace_name = 'UNDOTBS1';
-- 3. undo retention 값 확인
show parameter undo_retention;
alter system set undo_retention = 3600 scope=both;
show parameter undo_retention;
-- 4. retention guarantee 확인
select tablespace_name, retention from dba_tablespaces where tablespace_name = 'UNDOTBS1';
-- 5. retention guarantee 변경 및 확인
alter tablespace UNDOTBS1 retention guarantee;
select tablespace_name, retention from dba_tablespaces where tablespace_name = 'UNDOTBS1';