Friday, 14 June 2013

Oracle ASM Disks Space Utilization:


SELECT
name                                     group_name
, sector_size                              sector_size
, block_size                               block_size
, allocation_unit_size                     allocation_unit_size
, state                                    state
, type                                     type
, total_mb                                 total_mb
, (total_mb - free_mb)                     used_mb
, ROUND((1- (free_mb / total_mb))*100, 2)  pct_used
FROM
v$asm_diskgroup
ORDER BY
name
/


No comments:

Post a Comment