ÇöÀç »ç¿ëÁßÀÎ °¢ tablespaceÀÇ ¿©À¯°ø°£(freespace)ÀÌ ¾î´ÀÁ¤µµ ÀÖ´ÂÁö
È®ÀÎ
SVRMGR> select tablespace_name,sum(bytes),max(bytes) from dba_free_space group b
y tablespace_name;
TABLESPACE_NAME SUM(BYTES) MAX(BYTES)
------------------------------ ---------- ----------
BACKRUSH 1046069248 1046028288
DRSYS 16637952 16637952
INDX 20963328 20963328
RBS 22011904 7340032
SYSTEM 10551296 10420224
TEMP 20963328 20963328
TOOLS 10444800 10444800
USERS 20963328 20963328
8 rows selected.
SVRMGR>
SUM=ÇϳªÀÇ tablespace³»¿¡ ºÐ»êµÇ¾î ÀÖ´Â ¿©À¯°ø°£À» ÇÕÇÑ°ªÀÌ¸ç °¡Àå Å«°ª(MAX)Àº ºÐ»êµÇ¾î ÀÖ´Â ¿©À¯°ø°£Áß °¡Àå Å« °ø°£ÀÇ size¸¦ ÀǹÌ
|