테이블 스페이스를 보던중 궁금한 점이 생겨 문의 드립니다.


SQL> SELECT tablespace_name, SUM(bytes), MAX(bytes)
         FROM DBA_FREE_SPACE
         GROUP BY tablespace_name;

TABLESPACE_NAME                SUM(BYTES)  MAX(BYTES)                           
------------------------------ ----------      ----------                           
COSFIM                                  9018343424      4122935296                           
COSFIMIDX                              2306146304     1148190720                           
DTR                                        1758134272      1757347840                           
DTRIDX                                   1497694208      1496252416  
 ^--   이 스페이스는 안만들었는데. 왜 생기는지.                         

EXAMPLE                               73138176          71041024                           
SYSAUX                                  548470784        478085120                           
SYSTEM                                 553582592        513736704                           
UNDOTBS1                             7817723904       3976134656                           
USERS                                   2359296            2359296                           

9 rows selected. 

SQL> COL FILE_NAME FORMAT A40
SQL> COL TABLESPACE_NAME FORMAT A30
SQL> SET LINESIZE 150
SQL> SELECT b.file_name "FILE_NAME", -- datafile Name
  2  b.tablespace_name "TABLESPACE_NAME", -- TableSpace Name
  3  b.bytes / 1024 "TOTAL SIZE(KB)", -- 총 Bytes
  4  ((b.bytes - sum(nvl(a.bytes,0)))) / 1024 "USED(KB)", -- 사용한 용량
  5  (sum(nvl(a.bytes,0))) / 1024 "FREE SIZE(KB)", -- 남은 용량
  6  (sum(nvl(a.bytes,0)) / (b.bytes)) * 100 "FREE %" -- 남은 %
  7  FROM DBA_FREE_SPACE a, DBA_DATA_FILES b
  8  WHERE a.file_id(+) = b.file_id
  9  GROUP BY b.tablespace_name, b.file_name, b.bytes
 10  ORDER BY b.tablespace_name;

FILE_NAME                     TABLESPACE_NAME   TOTAL SIZE(KB)   USED(KB) FREE SIZE(KB)     FREE %                           
------------------           ------------------      -------------- ---------- ------------- ----------                           
D:\\COSFIM.ORA           COSFIM                    8089600            7224704            864896       10.6914557                           
D:\\COSFIM2.ORA          COSFIM                    8089600            147520              7942080      98.1764241                           
D:\\COSFIMIDX.ORA      COSFIMIDX                8192000            5939904             2252096      27.4914063                           
D:\\DTR.ORA                 DTR                           3379200            3379072            128             .003787879 <-- 이 부분이 모자란듯                         
D:\\DTR2.ORA               DTR                           3072000            1355200            1716800      55.8854167                           
D:\\DTRIDX.ORA            DTRIDX                      1792000            1790592            1408           .078571429 <-- 이 부분이 모자란듯                          
D:\\DTRIDX2.ORA           DTRIDX                     1792000             330816              1461184      81.5392857                            
     .
     .
     .
     .
     .
                                                                                                                                             
                                                                                                                                                     
이렇게 해서 궁금한점이..

1. 모자라면 어떻게 되는지.
2. 늘려주려면 어떻게 해야 하는지.
3. DTR 만 만들어 준걸로 알고 있는데 DTR2 가 왜 생겪는지.
4. DTRIDX 라는건 안만들어 주었는데.. 왜생겼는지와 그 밑에 또 DTRIDX2 도 왜 생겼는지가

궁금합니다.