set linesize 150
column name format a15
column state format a15
column type format a10
column totoal_mb format 99999
column free_mb format 99999
column pct_used format 99999
select name, state, type,
ROUND(total_mb/1024) as total_gb,
ROUND(free_mb/1024) as free_gb,
ROUND(cold_used_mb/1024) as cold_used_gb,
ROUND(hot_used_mb/1024) as hot_used_gb,
ROUND (cold_used_mb * 100 / total_mb) AS PCT_Used
from v$asm_diskgroup
order by name;
NAME STATE TYPE TOTAL_GB FREE_GB COLD_USED_GB HOT_USED_GB PCT_USED
--------------- --------------- ---------- ---------- ---------- ------------ ----------- --------
ACFS01 MOUNTED EXTERN 727 126 600 0 83
GRID MOUNTED NORMAL 50 41 9 0 18
RECO01 CONNECTED EXTERN 2180 2118 62 0 3
REDOLOG01 CONNECTED EXTERN 454 422 32 0 7
REDOLOG02 CONNECTED EXTERN 454 422 32 0 7
REG_DATA01 CONNECTED EXTERN 4541 3873 668 0 15
TEMP01 MOUNTED EXTERN 1816 1816 0 0 0
7 rows selected.
set linesize 150
column name format a20
column state format a15
column type format a15
column totoal_mb format 9999999
column free_mb format 9999999
select name, state, type,
total_mb,
free_mb,
cold_used_mb,
hot_used_mb
from v$asm_diskgroup
order by name;
NAME STATE TYPE TOTAL_MB FREE_MB COLD_USED_MB HOT_USED_MB
-------------------- --------------- --------------- ---------- -------- ------------ -----------
ACFS01 MOUNTED EXTERN 744036 129512 614524 0
GRID MOUNTED NORMAL 51195 41803 9392 0
RECO01 CONNECTED EXTERN 2232108 2168718 63390 0
REDOLOG01 CONNECTED EXTERN 465000 431816 33184 0
REDOLOG02 CONNECTED EXTERN 465000 431816 33184 0
REG_DATA01 CONNECTED EXTERN 4650225 3966449 683776 0
TEMP01 MOUNTED EXTERN 1860090 1859947 143 0
7 rows selected.