SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string C:\ORACLE\PRODUCT\19.3.0\DATAB
ASE\SPFILEORACLE.ORA
undo_retention
와 undo_tablespace
의 파라미터 변경 속성(issys_modifiable
) 파악immediate
이므로 바로 변경 가능SQL> select issys_modifiable from v$parameter where name='undo_retention';
ISSYS_MOD
---------
IMMEDIATE
SQL> select issys_modifiable from v$parameter where name='undo_tablespace';
ISSYS_MOD
---------
IMMEDIATE
undo_retention
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
temp_undo_enabled boolean FALSE
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL> alter system set undo_retention=3600;
시스템이 변경되었습니다.
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
temp_undo_enabled boolean FALSE
undo_management string AUTO
undo_retention integer 3600
undo_tablespace string UNDOTBS1
undo_tablespace
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
temp_undo_enabled boolean FALSE
undo_management string AUTO
undo_retention integer 3600
undo_tablespace string UNDOTBS1
SQL> alter system set undo_tablespace=UNDOTBS2;
시스템이 변경되었습니다.
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
temp_undo_enabled boolean FALSE
undo_management string AUTO
undo_retention integer 3600
undo_tablespace string UNDOTBS2