不死鳥のメモ

_ TABLESPACEの情報確認

TABLESPACEの情報確認
TABLESPACEの情報は[dba_data_files]を参照する事で確認出来る

SQL> column file_name heading "file_name" format a60
SQL> select * from dba_data_files;
FILE_NAME                                           FILE_ID TABLE_SPACE       BYTES  BLOCKS STATUS    RELATIVE_FNO AUT   MAXBYTES  MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS ONLINE_
-------------------------------------------------- -------- ------------ ---------- ------- --------- ------------ --- ---------- ---------- ------------ ---------- ----------- -------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\DB\SYSTEM01.DBF          1 SYSTEM        513802240   62720 AVAILABLE       1      YES 3.4360E+10    4194302         1280  513736704       62712 SYSTEM
C:\ORACLE\PRODUCT\10.2.0\ORADATA\DB\UNDOTBS01.DBF         2 UNDOTBS1       26214400    3200 AVAILABLE       2      YES 3.4360E+10    4194302          640   26148864        3192 ONLINE
C:\ORACLE\PRODUCT\10.2.0\ORADATA\DB\SYSAUX01.DBF          3 SYSAUX        293601280   35840 AVAILABLE       3      YES 3.4360E+10    4194302         1280  293535744       35832 ONLINE
C:\ORACLE\PRODUCT\10.2.0\ORADATA\DB\USERS01.DBF           4 USERS           5242880     640 AVAILABLE       4      YES 3.4360E+10    4194302          160    5177344         632 ONLINE
C:\ORACLE\PRODUCT\10.2.0\ORADATA\DB\EXAMPLE01.DBF         5 EXAMPLE       104857600   12800 AVAILABLE       5      YES 3.4360E+10    4194302           80  104792064       12792 ONLINE
C:\ORACLE\PRODUCT\10.2.0\ORADATA\DB\TEST.DBF              6 T_TEST        209715200   25600 AVAILABLE       6       NO          0          0            0  209649664       25592 ONLINE

FILE_NAME：物理ファイルの位置
FILE_ID
TABLE_SPACE：TABLESPACE NAME
BYTES
BLOCKS
STATUS
RELATIVE_FNO
AUT：自動拡張の可否
MAXBYTES
MAXBLOCKS
INCREMENT_BY
USER_BYTES
USER_BLOCKS
ONLINE_