ASM disk gruplarının listesini,boyutunu,kullanımını,kullanım oranını vs. veren query aşagıdaki gibidir.
SET LINESIZE 145 SET PAGESIZE 9999 SET VERIFY off COLUMN group_name FORMAT a20 HEAD 'Disk Group|Name' COLUMN sector_size FORMAT 99,999 HEAD 'Sector|Size' COLUMN block_size FORMAT 99,999 HEAD 'Block|Size' COLUMN allocation_unit_size FORMAT 999,999,999 HEAD 'Allocation|Unit Size' COLUMN state FORMAT a11 HEAD 'State' COLUMN type FORMAT a6 HEAD 'Type' COLUMN total_gb FORMAT 999,999,999 HEAD 'Total Size (GB)' COLUMN used_gb FORMAT 999,999,999 HEAD 'Used Size (GB)' COLUMN pct_used FORMAT 999.99 HEAD 'Pct. Used' break on report on disk_group_name skip 1 compute sum label "Grand Total: " of total_gb used_gb on report SELECT name group_name , sector_size sector_size , block_size block_size , allocation_unit_size allocation_unit_size , state state , type type , total_mb/1024 total_gb , (total_mb - free_mb)/1024 used_gb , ROUND((1- (free_mb / total_mb))*100, 2) pct_used FROM v$asm_diskgroup ORDER BY name /
Yararlı olması Dilegiyle…
Yazar : Mustafa Bektaş Tepe