asmsize

pbpmccracora1:/home/oracle>>cat .profile
# Purpose : Generic environment variable setup
# Created : 04-15-2007
########################################################
# Set up the Unix variables:
export EDITOR=vi
umask 022
set -o vi
alias ls='/bin/ls'
alias pso='ps -fu oracle'
alias asmsize='/opt/oracle/DBATOOLS/sql/asm/get_asmgroup_info.ksh'
# Setup Prompt
PS1=`uname -n`:'$PWD>>'

# . $HOME/.setup_ASM.ksh
. $HOME/.setup_PMCRCS20.ksh
# Setup all local environment here
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ENGG=/opt/oracle/DBAENGG/scripts
cd /opt/oracle/DBATOOLS/sql/general/
export TZ=EST5EDT
export COLUMNS=200
export SNACS=/opt/oracle/DBAENGG/scripts/CHECK_SNACID/
export AUDIT=/opt/oracle/DBAENGG/scripts/DBAUDIT/
export STANDBY=/opt/oracle/DBAENGG/scripts/STANDBY/
export TBS=/opt/oracle/DBAENGG/scripts/TBSCOLLECT/
export LOAD=/opt/oracle/DBAENGG/loadtest3/
export LOAD2=/opt/oracle/DBAENGG/LOADTEST2/
export LOAD4=/opt/oracle/DBAENGG/dboBENCH/
export ASH=/opt/oracle/DBAENGG/ASHWORK/
export SWING=/opt/oracle/SWINGB/swingbench/bin
if [ -t 0 ]; then
   stty intr ^C
fi
pbpmccracora1:/home/oracle>>ls -l /opt/oracle/DBATOOLS/sql/asm/get_asmgroup_info.ksh
-rwxr-xr-x 1 oracle oinstall 567 Mar 13  2007 /opt/oracle/DBATOOLS/sql/asm/get_asmgroup_info.ksh


pbpmccracora1:/home/oracle>>cat /opt/oracle/DBATOOLS/sql/asm/get_asmgroup_info.ksh
#!/bin/ksh
# It requires the .setup_<<DBANEM>>.ksh file
# so that ASM_SID and ORACLE_HOME of ASM exectable is set up properly ..
# ir read ASM_SID and ASM_HOME variables to make use ..
. ~/.profile
export ORACLE_SID=$ASM_SID
export ORACLE_HOME=$ASM_HOME
echo "======== On HostName: `uname -n` ========\n"
$ORACLE_HOME/bin/sqlplus -s /nolog  << EOF1
connect / as sysdba
 spool /tmp/asm_disks.log
 @/opt/oracle/DBATOOLS/sql/asm/show_asm_diskgroups.sql
 spool off
EOF1
# mail -s "Oracle:MIS ASM-DiskGroup for RMAN Registered db(s) " $MAILLIST < /tmp/asm_disks.log


pbpmccracora1:/home/oracle>>cat /opt/oracle/DBATOOLS/sql/asm/show_asm_diskgroups.sql
col name for a20 head 'ASM_DISK|Name'
col g_name for a12 head 'ASM_Group|Name'
col path for a20 head 'Disk|Path'
col DISK_NUMBER head 'DISK|NUM#'   for 99999
col GROUP_NUMBER head 'Grp|NUM' for 999
col HEADER_STATUS head 'HEADER|STATUS'
col MOUNT_STATUS head 'MOUNT|STATUS' for a8
col TOTAL_MB for 999,999,999
col FREE_MB for 999,999,999
col ALLOC for 99999 head 'Alloc|Unit_KB'
col SECTOR_SIZE head 'Sector|Size'
col Block_Size head 'Block|Size'
col offline_disks head 'Offline|Disks'
set linesize 140
set pagesize 140
PROMPT ***** LIST DISKS with Disk Groups under ASM control  ****
select A.NAME G_NAME, A.GROUP_NUMBER, b.DISK_NUMBER,
b.MOUNT_STATUS, b.HEADER_STATUS,
b.STATE, b.PATH, b.NAME, b.TOTAL_MB, b.FREE_MB, round(b.FREE_MB/b.TOTAL_MB * 100,1) PCT_FREE
from v$asm_disk B, v$asm_diskgroup A
where A.GROUP_NUMBER = B.GROUP_NUMBER
order by A.NAME
/
PROMPT ***** Disk Group Details under ASM control  ****
select NAME g_name, TYPE, TOTAL_MB, FREE_MB, round(FREE_MB/TOTAL_MB * 100,1) PCT_FREE,
BLOCK_SIZE, SECTOR_SIZe, OFFLINE_DISKS, ALLOCATION_UNIT_SIZE/1024 Alloc,
STATE from v$asm_diskgroup
/