临时表空间扩容
#临时表空间扩容
```
SYS@kecssdb1> SELECT * FROM (
2 SELECT file_name , tablespace_name ,file_id,'datafile' AS TYPE
3 FROM DBA_DATA_FILES
4 UNION ALL
5 SELECT file_name , tablespace_name ,file_id + value ,'tempfile '
6 FROM DBA_TEMP_FILES , v$parameter p
7 WHERE p.name = 'db_files'
8 );
FILE_NAME TABLESPACE_NAME FILE_ID TYPE
-------------------------------------------------- ------------------------------ ---------- ---------
+KECSSDG/kecssdb/datafile/ecss.266.918130691 ECSS 6 datafile
+KECSSDG/kecssdb/datafile/ecss.265.918130837 ECSS 7 datafile
+KECSSDG/kecssdb/datafile/ecss.262.918130881 ECSS 8 datafile
+KECSSDG/kecssdb/datafile/users.259.917773531 USERS 4 datafile
+KECSSDG/kecssdb/datafile/undotbs1.258.917773531 UNDOTBS1 3 datafile
+KECSSDG/kecssdb/datafile/sysaux.257.917773531 SYSAUX 2 datafile
+KECSSDG/kecssdb/datafile/system.256.917773531 SYSTEM 1 datafile
+KECSSDG/kecssdb/datafile/undotbs2.264.917773607 UNDOTBS2 5 datafile
+KECSSDG/kecssdb/datafile/lobtable01.261.918133257 LOBTABLE01 9 datafile
+KECSSDG/kecssdb/datafile/indexecss.281.918140863 INDEXECSS 10 datafile
+KECSSDG/kecssdb/datafile/ecisp_data.283.921936913 ECISP_DATA 11 datafile
+KECSSDG/kecssdb/datafile/undotbs1.285.929439505 UNDOTBS1 12 datafile
+KECSSDG/kecssdb/tempfile/ecisp_temp.284.921937025 ECISP_TEMP 202 tempfile
+KECSSDG/kecssdb/tempfile/temp04.271.918127741 TEMP04 205 tempfile
+KECSSDG/kecssdb/tempfile/temp03.270.918127735 TEMP03 204 tempfile
+KECSSDG/kecssdb/tempfile/temp02.269.918127727 TEMP02 203 tempfile
+KECSSDG/kecssdb/tempfile/temp01.263.918127721 TEMP01 201 tempfile
SYS@kecssdb1> SELECT D.TABLESPACE_NAME,SPACE "SUM_SPACE(M)",BLOCKS SUM_BLOCKS,
2 USED_SPACE "USED_SPACE(M)",ROUND(NVL(USED_SPACE,0)/SPACE*100,2) "USED_RATE(%)",
3 NVL(FREE_SPACE,0) "FREE_SPACE(M)"
4 FROM
5 (SELECT TABLESPACE_NAME,ROUND(SUM(BYTES)/(1024*1024),2) SPACE,SUM(BLOCKS) BLOCKS
6 FROM DBA_TEMP_FILES
7 GROUP BY TABLESPACE_NAME) D,
8 (SELECT TABLESPACE_NAME,ROUND(SUM(BYTES_USED)/(1024*1024),2) USED_SPACE,
9 ROUND(SUM(BYTES_FREE)/(1024*1024),2) FREE_SPACE
10 FROM V$TEMP_SPACE_HEADER
11 GROUP BY TABLESPACE_NAME) F
12 WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME(+);
TABLESPACE_NAME SUM_SPACE(M) SUM_BLOCKS USED_SPACE(M) USED_RATE(%) FREE_SPACE(M)
------------------------------ ------------ ---------- ------------- ------------ -------------
TEMP02 10240 1310720 10141 99.03 99
TEMP04 10240 1310720 10141 99.03 99
TEMP01 10240 1310720 10141 99.03 99
TEMP03 10240 1310720 10141 99.03 99
ECISP_TEMP 32 4096 1 3.13 31
Elapsed: 00:00:00.03
SYS@kecssdb1>
SYS@kecssdb1>
SYS@kecssdb1> ALTER TABLESPACE TEMP01 ADD TEMPFILE '+KECSSDG' SIZE 20G;
Tablespace altered.
Elapsed: 00:00:02.93
```
