|
±Û¾´ÀÌ : ÁÁÀºÁøÈ£(truefeel, http://coffeenix.net/ )
±Û¾´³¯ : 1999.11(?)
ÇöÀç Á¢¼ÓÇÑ DB user°¡ »ç¿ëÇÑ Å×ÀÌºí½ºÆäÀ̽º ¿ë·®°ú ³²Àº ¿ë·® È®ÀÎ.
SET LINESIZE 90
SELECT USE.TABLESPACE_NAME,
(USE.U_BYTES + FREE.F_BYTES) AS "ÇÒ´ç KB",
USE.U_BYTES AS "»ç¿ë KB", USE.U_BLOCKS AS "»ç¿ë BLOCKS",
FREE.F_BYTES AS "³²Àº KB", FREE.F_BLOCKS AS "³²Àº BLOCKS"
FROM
( SELECT TABLESPACE_NAME, SUM(bytes)/1024 AS U_BYTES, SUM(blocks) AS U_BLOCKS
FROM USER_TS_QUOTAS GROUP BY TABLESPACE_NAME) USE,
( SELECT TABLESPACE_NAME, SUM(bytes)/1024 AS F_BYTES, SUM(blocks) AS F_BLOCKS
FROM USER_FREE_SPACE GROUP BY TABLESPACE_NAME) FREE
WHERE USE.TABLESPACE_NAME = FREE.TABLESPACE_NAME;
|