[ORACLE] ASM 접속 및 용량 조회

1. ASMCMD

-. asmcmd 

ASMCMD> pwd
+DATA/ORCL/DATAFILE
ASMCMD> ls   
SYSAUX.260.1095025303
SYSTEM.259.1095025267
UNDOTBS1.261.1095025327
UNDOTBS2.271.1095026407
USERS.262.1095025329

용량 조회

col name format a10
col USABLE_FILE_GB format 999,999.00
col TOTAL_GB       format 999,999.00
col FREE_GB        format 999,999.00
col USABLE_CALC_GB format 999,999.00
set line 250

select name,
       USABLE_FILE_MB/1024 USABLE_FILE_GB,
       total_mb/1024 TOTAL_GB, free_mb/1024 FREE_GB,
       100-round(free_mb/total_mb*100) "usgae(%)",
        ((FREE_MB - REQUIRED_MIRROR_FREE_MB))/1024 USABLE_CALC_GB,
       state, type, group_number
from v$asm_diskgroup;


NAME	   USABLE_FILE_GB    TOTAL_GB	  FREE_GB   usgae(%) USABLE_CALC_GB STATE	TYPE   GROUP_NUMBER
---------- -------------- ----------- ----------- ---------- -------------- ----------- ------ ------------
DATA		    27.07	31.98	    27.07	  15	      27.07 CONNECTED	EXTERN		  1