オラクル表領域拡張の詳細

SELECT TABLESPACE_NAME "tablespace",
       To_char(Round(BYTES / 1024, 2), '99990.00')
       || '' "real",
       To_char(Round(FREE / 1024, 2), '99990.00')
       || 'G' "existing",
       To_char(Round(( BYTES - FREE ) / 1024, 2), '99990.00')
       || 'G' "use",
       To_char(Round(10000 * USED / BYTES) / 100, '99990.00')
       || '%' "ratio"
FROM (SELECT A.TABLESPACE_NAME TABLESPACE_NAME,
               Floor(A.BYTES / ( 1024 * 1024 )) BYTES,
               Floor(B.FREE / ( 1024 * 1024 )) FREE,
               Floor(( A.BYTES - B.FREE ) / ( 1024 * 1024 )) USED
        FROM (SELECT TABLESPACE_NAME TABLESPACE_NAME,
                       Sum(BYTES) BYTES
                FROM DBA_DATA_FILES
                GROUP BY TABLESPACE_NAME) A,
               (SELECT TABLESPACE_NAME TABLESPACE_NAME,
                       Sum(BYTES) FREE
                FROM DBA_FREE_SPACE
                GROUP BY TABLESPACE_NAME) B
        WHERE A.TABLESPACE_NAME = B.TABLESPACE_NAME)
--WHERE TABLESPACE_NAME LIKE 'CDR%' -- This sentence is used to specify the tablespace name
ORDER BY Floor(10000 * USED / BYTES) DESC;

select b.file_id File ID,
　　b.tablespace_name tablespace,
　　b.file_name physical file name,
　　b.bytes Total number of bytes,
　　(b.bytes-sum(nvl(a.bytes,0))) used,
　　sum(nvl(a.bytes,0)) remaining,
　　sum(nvl(a.bytes,0))/(b.bytes)*100 percentage remaining
　　from dba_free_space a,dba_data_files b
　　where a.file_id=b.file_id
　　group by b.tablespace_name,b.file_name,b.file_id,b.bytes
　　order by b.tablespace_name
 

ALTER TABLESPACE app_data ADD DATAFILE
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\EDWTEST\APP03.DBF' SIZE 20480M;

ALTER DATABASE DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\EDWTEST\APP03.DBF'
AUTOEXTEND ON NEXT 100M MAXSIZE 20480M; 

ALTER TABLESPACE SYSTEM ADD DATAFILE
'C:\APP\ORACLE\ORADATA\DFYYCDB\DATAFILE\O2_MF_SYSTEM_CWMNZ9XV_.DBF' 
size 7167M autoextend on ;
ALTER TABLESPACE SYSTEM ADD DATAFILE
'C:\APP\ORACLE\ORADATA\DFYYCDB\DATAFILE\O3_MF_SYSTEM_CWMNZ9XV_.DBF' 
size 7167M autoextend on ;