Shulou(Shulou.com)06/01 Report--

Oracle 12cR1 RAC

Col sid for a10col name for a20col value for a20select sid,name,value from v$spparameter where name='undo_tablespace' SID NAME VALUE--orcl2 undo_tablespace UNDOTBS2orcl1 undo_tablespace UNDOTBS1SYS@orcl1 > show parameter create_fileNAME TYPE VALUE- -db_create_file_dest string + DATADGSYS@orcl1 > SYS@orcl1 > show parameter undoNAME TYPE VALUE-- temp_undo_enabled boolean FALSEundo_management string AUTOundo_retention integer 900undo_tablespace string UNDOTBS1-- does not extend automatically There is no maximum value SYS@orcl1 > alter tablespace undotbs1 add datafile size 10m SYS@orcl1 > alter tablespace undotbs2 add datafile size 20m-expand to 30mSYS@orcl1 > alter database datafile'+ DATADG/ORCL/DATAFILE/undotbs2.273.964970069' resize 30m-automatic expansion, maximum 100MSYS@orcl1 > alter database datafile'+ DATADG/ORCL/DATAFILE/undotbs2.273.964970069' autoextend on maxsize 100mcol file_name for a50set lines 200select 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 100+DATADG/ORCL/DATAFILE/ undotbs2.369.965681285 20 0

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.