Oracle 12cR1 RAC

為黃陵等地區(qū)用戶提供了全套網(wǎng)頁(yè)設(shè)計(jì)制作服務(wù)，及黃陵網(wǎng)站建設(shè)行業(yè)解決方案。主營(yíng)業(yè)務(wù)為成都網(wǎng)站建設(shè)、做網(wǎng)站、黃陵網(wǎng)站設(shè)計(jì)，以傳統(tǒng)方式定制建設(shè)網(wǎng)站，并提供域名空間備案等一條龍服務(wù)，秉承以專業(yè)、用心的態(tài)度為用戶提供真誠(chéng)的服務(wù)。我們深信只要達(dá)到每一位用戶的要求，就會(huì)得到認(rèn)可，從而選擇與我們長(zhǎng)期合作。這樣，我們也可以走得更遠(yuǎn)！

col sid for a10
col name for a20
col value for a20
select sid,name,value from v$spparameter where name='undo_tablespace';

SID        NAME                 VALUE
---------- ------------------------------ --------------------
orcl2      undo_tablespace      UNDOTBS2
orcl1      undo_tablespace      UNDOTBS1

SYS@orcl1> show parameter create_file

NAME                   TYPE          VALUE
------------------------------------ ---------------------- ------------------------------
db_create_file_dest        string         +DATADG
SYS@orcl1> 
SYS@orcl1> show parameter undo

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
temp_undo_enabled             boolean               FALSE
undo_management               string                   AUTO
undo_retention                       integer                900
undo_tablespace                   string                  UNDOTBS1

--不自動(dòng)擴(kuò)展，沒(méi)有最大值
SYS@orcl1> alter tablespace undotbs1 add datafile  size 10m;
SYS@orcl1> alter tablespace undotbs2 add datafile  size 20m;
--擴(kuò)容到30m
SYS@orcl1> alter database datafile '+DATADG/ORCL/DATAFILE/undotbs2.273.964970069' resize 30m;
--自動(dòng)擴(kuò)展，最大100M
SYS@orcl1> alter database datafile '+DATADG/ORCL/DATAFILE/undotbs2.273.964970069' autoextend on maxsize 100m;

col file_name for a50
set lines 200
select file_name,bytes/1024/1024 mb,maxbytes/1024/1024 max_mb from dba_data_files where tablespace_name like 'UNDOTBS%';
FILE_NAME                                                                            MB     MAX_MB
---------------------------------------------------------------------------- ------------- ----------
+DATADG/ORCL/DATAFILE/undotbs1.261.964970069      155 32767.9844
+DATADG/ORCL/DATAFILE/undotbs2.273.964970069      30        100
+DATADG/ORCL/DATAFILE/undotbs1.367.965681119      10          0
+DATADG/ORCL/DATAFILE/undotbs2.369.965681285      20          0