테이블스페이스의 사용 가능한 공간과 단편화(fragmentation)에 대한 정보
【예제】
SQL> desc dba_free_space;
Name Null? Type
----------------------------------------- -------- ----------------------------
TABLESPACE_NAME VARCHAR2(30)
FILE_ID NUMBER
BLOCK_ID NUMBER
BYTES NUMBER
BLOCKS NUMBER
RELATIVE_FNO NUMBER
SQL> select * from dba_free_space;
TABLESPACE FILE_ID BLOCK_ID BYTES BLOCKS RELATIVE_FNO
---------- ---------- ---------- ---------- ---------- ------------
SYSTEM 1 61297 196608 24 1
SYSTEM 1 62217 4128768 504 1
UNDOTBS1 2 161 524288 64 2
UNDOTBS1 2 233 65536 8 2
UNDOTBS1 2 1033 4194304 512 2
UNDOTBS1 2 1673 1048576 128 2
UNDOTBS1 2 2057 3145728 384 2
UNDOTBS1 2 2569 19922944 2432 2
UNDOTBS1 2 5129 5242880 640 2
UNDOTBS1 2 5897 5242880 640 2
UNDOTBS1 2 6665 81723392 9976 2
SYSAUX 3 31025 65536 8 3
SYSAUX 3 31041 196608 24 3
SYSAUX 3 31089 131072 16 3
SYSAUX 3 31129 262144 32 3
SYSAUX 3 31177 65536 8 3
SYSAUX 3 31193 458752 56 3
SYSAUX 3 31257 131072 16 3
SYSAUX 3 31289 131072 16 3
SYSAUX 3 31345 131072 16 3
SYSAUX 3 31369 196608 24 3
SYSAUX 3 31401 131072 16 3
SYSAUX 3 31425 65536 8 3
SYSAUX 3 32273 262144 32 3
SYSAUX 3 32313 65536 8 3
SYSAUX 3 32329 196608 24 3
SYSAUX 3 32537 131072 16 3
SYSAUX 3 32569 65536 8 3
SYSAUX 3 32593 65536 8 3
SYSAUX 3 32625 131072 16 3
SYSAUX 3 32673 65536 8 3
SYSAUX 3 32737 983040 120 3
SYSAUX 3 32873 65536 8 3
SYSAUX 3 32889 131072 16 3
SYSAUX 3 33049 196608 24 3
SYSAUX 3 33089 65536 8 3
SYSAUX 3 33137 262144 32 3
SYSAUX 3 33185 262144 32 3
SYSAUX 3 33225 196608 24 3
SYSAUX 3 33265 65536 8 3
SYSAUX 3 33281 196608 24 3
SYSAUX 3 33313 262144 32 3
SYSAUX 3 33353 65536 8 3
SYSAUX 3 33369 196608 24 3
SYSAUX 3 33401 524288 64 3
SYSAUX 3 33473 65536 8 3
SYSAUX 3 33505 131072 16 3
TABLESPACE FILE_ID BLOCK_ID BYTES BLOCKS RELATIVE_FNO
---------- ---------- ---------- ---------- ---------- ------------
SYSAUX 3 33529 327680 40 3
SYSAUX 3 33689 131072 16 3
SYSAUX 3 33729 589824 72 3
SYSAUX 3 34057 917504 112 3
SYSAUX 3 34185 131072 16 3
SYSAUX 3 34225 458752 56 3
SYSAUX 3 34289 262144 32 3
SYSAUX 3 34345 65536 8 3
SYSAUX 3 34361 327680 40 3
SYSAUX 3 34409 327680 40 3
SYSAUX 3 34457 131072 16 3
SYSAUX 3 34481 196608 24 3
SYSAUX 3 34513 131072 16 3
SYSAUX 3 34537 65536 8 3
SYSAUX 3 34569 131072 16 3
SYSAUX 3 34593 327680 40 3
SYSAUX 3 34641 131072 16 3
SYSAUX 3 34881 65536 8 3
SYSAUX 3 34945 65536 8 3
SYSAUX 3 35081 393216 48 3
SYSAUX 3 35137 65536 8 3
SYSAUX 3 35153 327680 40 3
SYSAUX 3 35201 65536 8 3
SYSAUX 3 35337 262144 32 3
SYSAUX 3 35377 131072 16 3
SYSAUX 3 35401 131072 16 3
SYSAUX 3 35449 262144 32 3
SYSAUX 3 35489 196608 24 3
SYSAUX 3 35521 196608 24 3
SYSAUX 3 35553 131072 16 3
SYSAUX 3 35577 393216 48 3
SYSAUX 3 35633 262144 32 3
SYSAUX 3 35673 131072 16 3
SYSAUX 3 35697 458752 56 3
SYSAUX 3 35769 65536 8 3
SYSAUX 3 35793 65536 8 3
SYSAUX 3 35809 393216 48 3
SYSAUX 3 35865 196608 24 3
SYSAUX 3 35953 65536 8 3
SYSAUX 3 35969 65536 8 3
SYSAUX 3 36233 262144 32 3
SYSAUX 3 36273 1048576 128 3
SYSAUX 3 36409 458752 56 3
SYSAUX 3 36489 458752 56 3
SYSAUX 3 36561 196608 24 3
SYSAUX 3 36593 65536 8 3
SYSAUX 3 36769 65536 8 3
TABLESPACE FILE_ID BLOCK_ID BYTES BLOCKS RELATIVE_FNO
---------- ---------- ---------- ---------- ---------- ------------
SYSAUX 3 36785 196608 24 3
SYSAUX 3 36817 262144 32 3
SYSAUX 3 36881 196608 24 3
SYSAUX 3 36929 458752 56 3
SYSAUX 3 37001 65536 8 3
SYSAUX 3 37017 131072 16 3
SYSAUX 3 37041 65536 8 3
SYSAUX 3 37057 131072 16 3
SYSAUX 3 37081 65536 8 3
SYSAUX 3 37097 327680 40 3
SYSAUX 3 37161 786432 96 3
SYSAUX 3 37513 786432 96 3
SYSAUX 3 37617 65536 8 3
SYSAUX 3 37681 262144 32 3
SYSAUX 3 37721 262144 32 3
SYSAUX 3 37769 131072 16 3
SYSAUX 3 37793 524288 64 3
SYSAUX 3 37873 327680 40 3
SYSAUX 3 37929 327680 40 3
SYSAUX 3 37977 65536 8 3
SYSAUX 3 37993 65536 8 3
SYSAUX 3 38009 131072 16 3
SYSAUX 3 38153 131072 16 3
SYSAUX 3 38193 262144 32 3
SYSAUX 3 38233 131072 16 3
SYSAUX 3 38265 720896 88 3
SYSAUX 3 38361 65536 8 3
SYSAUX 3 38385 65536 8 3
SYSAUX 3 38401 65536 8 3
SYSAUX 3 38537 1048576 128 3
SYSAUX 3 38921 327680 40 3
SYSAUX 3 38969 655360 80 3
SYSAUX 3 39057 131072 16 3
SYSAUX 3 39081 393216 48 3
SYSAUX 3 39145 65536 8 3
SYSAUX 3 39161 131072 16 3
SYSAUX 3 39441 327680 40 3
SYSAUX 3 39489 131072 16 3
SYSAUX 3 39513 65536 8 3
SYSAUX 3 39529 196608 24 3
SYSAUX 3 39561 458752 56 3
SYSAUX 3 39625 131072 16 3
SYSAUX 3 39649 327680 40 3
SYSAUX 3 40073 327680 40 3
SYSAUX 3 40121 655360 80 3
SYSAUX 3 40329 655360 80 3
SYSAUX 3 40417 262144 32 3
TABLESPACE FILE_ID BLOCK_ID BYTES BLOCKS RELATIVE_FNO
---------- ---------- ---------- ---------- ---------- ------------
SYSAUX 3 40457 1114112 136 3
SYSAUX 3 40601 589824 72 3
SYSAUX 3 40681 1310720 160 3
SYSAUX 3 41225 196608 24 3
SYSAUX 3 41257 393216 48 3
SYSAUX 3 41313 196608 24 3
SYSAUX 3 41345 524288 64 3
SYSAUX 3 41425 196608 24 3
SYSAUX 3 41457 196608 24 3
SYSAUX 3 41737 589824 72 3
SYSAUX 3 41817 983040 120 3
SYSAUX 3 41945 393216 48 3
SYSAUX 3 42249 262144 32 3
SYSAUX 3 42289 589824 72 3
SYSAUX 3 43145 655360 80 3
SYSAUX 3 43233 458752 56 3
SYSAUX 3 43305 393216 48 3
SYSAUX 3 43361 196608 24 3
SYSAUX 3 43393 65536 8 3
SYSAUX 3 43665 65536 8 3
SYSAUX 3 43689 786432 96 3
SYSAUX 3 44169 1507328 184 3
SYSAUX 3 44361 3604480 440 3
USERS 4 385 2097152 256 4
EXAMPLE 5 1009 458752 56 5
EXAMPLE 5 8793 32833536 4008 5
167 rows selected.
SQL> desc user_free_space;
Name Null? Type
----------------------------------------- -------- ----------------------------
TABLESPACE_NAME VARCHAR2(30)
FILE_ID NUMBER
BLOCK_ID NUMBER
BYTES NUMBER
BLOCKS NUMBER
RELATIVE_FNO NUMBER
SQL> select * from user_free_space;
TABLESPACE FILE_ID BLOCK_ID BYTES BLOCKS RELATIVE_FNO
---------- ---------- ---------- ---------- ---------- ------------
SYSTEM 1 61297 196608 24 1
SYSTEM 1 62217 4128768 504 1
UNDOTBS1 2 161 524288 64 2
UNDOTBS1 2 233 65536 8 2
UNDOTBS1 2 1033 4194304 512 2
UNDOTBS1 2 1673 1048576 128 2
UNDOTBS1 2 2057 3145728 384 2
UNDOTBS1 2 2569 19922944 2432 2
UNDOTBS1 2 5129 5242880 640 2
UNDOTBS1 2 5897 5242880 640 2
UNDOTBS1 2 6665 81723392 9976 2
SYSAUX 3 31025 65536 8 3
SYSAUX 3 31041 196608 24 3
SYSAUX 3 31089 131072 16 3
SYSAUX 3 31129 262144 32 3
SYSAUX 3 31177 65536 8 3
SYSAUX 3 31193 458752 56 3
SYSAUX 3 31257 131072 16 3
SYSAUX 3 31289 131072 16 3
SYSAUX 3 31345 131072 16 3
SYSAUX 3 31369 196608 24 3
SYSAUX 3 31401 131072 16 3
SYSAUX 3 31425 65536 8 3
SYSAUX 3 32273 262144 32 3
SYSAUX 3 32313 65536 8 3
SYSAUX 3 32329 196608 24 3
SYSAUX 3 32537 131072 16 3
SYSAUX 3 32569 65536 8 3
SYSAUX 3 32593 65536 8 3
SYSAUX 3 32625 131072 16 3
SYSAUX 3 32673 65536 8 3
SYSAUX 3 32737 983040 120 3
SYSAUX 3 32873 65536 8 3
SYSAUX 3 32889 131072 16 3
SYSAUX 3 33049 196608 24 3
SYSAUX 3 33089 65536 8 3
SYSAUX 3 33137 262144 32 3
SYSAUX 3 33185 262144 32 3
SYSAUX 3 33225 196608 24 3
SYSAUX 3 33265 65536 8 3
SYSAUX 3 33281 196608 24 3
SYSAUX 3 33313 262144 32 3
SYSAUX 3 33353 65536 8 3
SYSAUX 3 33369 196608 24 3
SYSAUX 3 33401 524288 64 3
SYSAUX 3 33473 65536 8 3
SYSAUX 3 33505 131072 16 3
TABLESPACE FILE_ID BLOCK_ID BYTES BLOCKS RELATIVE_FNO
---------- ---------- ---------- ---------- ---------- ------------
SYSAUX 3 33529 327680 40 3
SYSAUX 3 33689 131072 16 3
SYSAUX 3 33729 589824 72 3
SYSAUX 3 34057 917504 112 3
SYSAUX 3 34185 131072 16 3
SYSAUX 3 34225 458752 56 3
SYSAUX 3 34289 262144 32 3
SYSAUX 3 34345 65536 8 3
SYSAUX 3 34361 327680 40 3
SYSAUX 3 34409 327680 40 3
SYSAUX 3 34457 131072 16 3
SYSAUX 3 34481 196608 24 3
SYSAUX 3 34513 131072 16 3
SYSAUX 3 34537 65536 8 3
SYSAUX 3 34569 131072 16 3
SYSAUX 3 34593 327680 40 3
SYSAUX 3 34641 131072 16 3
SYSAUX 3 34881 65536 8 3
SYSAUX 3 34945 65536 8 3
SYSAUX 3 35081 393216 48 3
SYSAUX 3 35137 65536 8 3
SYSAUX 3 35153 327680 40 3
SYSAUX 3 35201 65536 8 3
SYSAUX 3 35337 262144 32 3
SYSAUX 3 35377 131072 16 3
SYSAUX 3 35401 131072 16 3
SYSAUX 3 35449 262144 32 3
SYSAUX 3 35489 196608 24 3
SYSAUX 3 35521 196608 24 3
SYSAUX 3 35553 131072 16 3
SYSAUX 3 35577 393216 48 3
SYSAUX 3 35633 262144 32 3
SYSAUX 3 35673 131072 16 3
SYSAUX 3 35697 458752 56 3
SYSAUX 3 35769 65536 8 3
SYSAUX 3 35793 65536 8 3
SYSAUX 3 35809 393216 48 3
SYSAUX 3 35865 196608 24 3
SYSAUX 3 35953 65536 8 3
SYSAUX 3 35969 65536 8 3
SYSAUX 3 36233 262144 32 3
SYSAUX 3 36273 1048576 128 3
SYSAUX 3 36409 458752 56 3
SYSAUX 3 36489 458752 56 3
SYSAUX 3 36561 196608 24 3
SYSAUX 3 36593 65536 8 3
SYSAUX 3 36769 65536 8 3
TABLESPACE FILE_ID BLOCK_ID BYTES BLOCKS RELATIVE_FNO
---------- ---------- ---------- ---------- ---------- ------------
SYSAUX 3 36785 196608 24 3
SYSAUX 3 36817 262144 32 3
SYSAUX 3 36881 196608 24 3
SYSAUX 3 36929 458752 56 3
SYSAUX 3 37001 65536 8 3
SYSAUX 3 37017 131072 16 3
SYSAUX 3 37041 65536 8 3
SYSAUX 3 37057 131072 16 3
SYSAUX 3 37081 65536 8 3
SYSAUX 3 37097 327680 40 3
SYSAUX 3 37161 786432 96 3
SYSAUX 3 37513 786432 96 3
SYSAUX 3 37617 65536 8 3
SYSAUX 3 37681 262144 32 3
SYSAUX 3 37721 262144 32 3
SYSAUX 3 37769 131072 16 3
SYSAUX 3 37793 524288 64 3
SYSAUX 3 37873 327680 40 3
SYSAUX 3 37929 327680 40 3
SYSAUX 3 37977 65536 8 3
SYSAUX 3 37993 65536 8 3
SYSAUX 3 38009 131072 16 3
SYSAUX 3 38153 131072 16 3
SYSAUX 3 38193 262144 32 3
SYSAUX 3 38233 131072 16 3
SYSAUX 3 38265 720896 88 3
SYSAUX 3 38361 65536 8 3
SYSAUX 3 38385 65536 8 3
SYSAUX 3 38401 65536 8 3
SYSAUX 3 38537 1048576 128 3
SYSAUX 3 38921 327680 40 3
SYSAUX 3 38969 655360 80 3
SYSAUX 3 39057 131072 16 3
SYSAUX 3 39081 393216 48 3
SYSAUX 3 39145 65536 8 3
SYSAUX 3 39161 131072 16 3
SYSAUX 3 39441 327680 40 3
SYSAUX 3 39489 131072 16 3
SYSAUX 3 39513 65536 8 3
SYSAUX 3 39529 196608 24 3
SYSAUX 3 39561 458752 56 3
SYSAUX 3 39625 131072 16 3
SYSAUX 3 39649 327680 40 3
SYSAUX 3 40073 327680 40 3
SYSAUX 3 40121 655360 80 3
SYSAUX 3 40329 655360 80 3
SYSAUX 3 40417 262144 32 3
TABLESPACE FILE_ID BLOCK_ID BYTES BLOCKS RELATIVE_FNO
---------- ---------- ---------- ---------- ---------- ------------
SYSAUX 3 40457 1114112 136 3
SYSAUX 3 40601 589824 72 3
SYSAUX 3 40681 1310720 160 3
SYSAUX 3 41225 196608 24 3
SYSAUX 3 41257 393216 48 3
SYSAUX 3 41313 196608 24 3
SYSAUX 3 41345 524288 64 3
SYSAUX 3 41425 196608 24 3
SYSAUX 3 41457 196608 24 3
SYSAUX 3 41737 589824 72 3
SYSAUX 3 41817 983040 120 3
SYSAUX 3 41945 393216 48 3
SYSAUX 3 42249 262144 32 3
SYSAUX 3 42289 589824 72 3
SYSAUX 3 43145 655360 80 3
SYSAUX 3 43233 458752 56 3
SYSAUX 3 43305 393216 48 3
SYSAUX 3 43361 196608 24 3
SYSAUX 3 43393 65536 8 3
SYSAUX 3 43665 65536 8 3
SYSAUX 3 43689 786432 96 3
SYSAUX 3 44169 1507328 184 3
SYSAUX 3 44361 3604480 440 3
USERS 4 385 2097152 256 4
EXAMPLE 5 1009 458752 56 5
EXAMPLE 5 8793 32833536 4008 5
167 rows selected.
SQL>