¿À¶óŬ DB userÀÇ Å×ÀÌºí½ºÆäÀ̽ºÀÇ »ç¿ë¿ë·® È®ÀÎ | ÀÛ¼ºÀÏ : 2003/08/05 01:16 |
Á¶È¸¼ö : 15120 |
±Û¾´ÀÌ : ÁÁÀºÁøÈ£(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; |
Ä¿ÇǴнº, ½Ã½ºÅÛ ¿£Áö´Ï¾îÀÇ ½°ÅÍ / URL : http://coffeenix.net/board_view.php?bd_code=9 |