Re: 오늘의 마지막 문제.골든 타임을 지정하는 undo_retention을 1시간으로 변경하고 ...

[21기_이풍혁]

-- 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';