Oracle ASM
Jump to navigation
Jump to search
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