Oracle ASM

script per controllo spazi

#!/bin/sh

ORACLE_SID=+ASM
ORAENV_ASK=NO
export ORACLE_SID ORAENV_ASK
. oraenv
unset ORAENV_ASK

sqlplus -s '/ as sysdba' << EOF
--desc v\$asm_diskgroup
--desc v\$asm_disk

set pagesize 200
set linesize 200


col PATH for a30
select d.NAME NAME
      ,d.HEADER_STATUS HEADER_STATUS
      ,d.STATE STATE
      ,d.TOTAL_MB TOTAL_MB
      ,d.FREE_MB
      ,d.PATH PATH
 from v\$asm_disk d
 where d.GROUP_NUMBER=0;

select g.NAME GROUPNAME
      ,d.NAME NAME
      ,d.HEADER_STATUS HEADER_STATUS
      ,d.STATE STATE
      ,d.TOTAL_MB TOTAL_MB
      ,d.FREE_MB
      ,d.PATH PATH
 from v\$asm_disk d, v\$asm_diskgroup g
 where d.GROUP_NUMBER=g.GROUP_NUMBER
   and d.GROUP_NUMBER!=0;

select GROUP_NUMBER,NAME,STATE,TYPE,TOTAL_MB,FREE_MB,OFFLINE_DISKS,UNBALANCED
 from v\$asm_diskgroup;
EOF