oracle学习之-临时表空间使用情况

   select t.* from v$sort_usage t--当前有多少临时表空间被使用
SELECT * FROM Dba_Data_Files WHERE tablespace_name ='NOAP_PERF_SAS'
alter tablespace NOAP_PERF_SAS add datafile '+DATA/noap/datafile/noap_perf_data28.dbf' size 60G autoextend on next 50M;
alter tablespace NOAP_PERF_SAS add datafile '+DATA/noap/datafile/noap_perf_data28.dbf' size 60G autoextend on next 50M;
alter tablespace mod_data add datafile '+DATADG/mod_data02.dbf' size 60G autoextend off;