#!/bin/ksh #******************************************************************************* # INITIALIZATION #******************************************************************************* export s_parmcount=$# export s_myName=`basename $0` # remember my name export s_sek=`date +'%S'` export s_min=`date +'%M'` export s_std=`date +'%H'` export s_tag=`date +'%d'` export s_mon=`date +'%m'` export s_jhr=`date +'%Y'` export s_now="$s_jhr$s_mon$s_tag$s_std$s_min$s_sek" export s_parmcountExpected=3 # initiate expected number of input parameters export s_rc=0 # initiate return code if [[ $s_parmcount -ne $s_parmcountExpected ]] then print -u2 "`basename $0`: USAGE: `basename $0` !" exit 1 else export s_instance=$(echo $1 | tr '[:lower:]' '[:upper:]') export s_user=$2 export s_pw=$3 export s_host=$(hostname) fi s_tmpfile=tmp/$(echo $s_myName | sed -e's/\.ksh/\.tmp/') mkdir err 2>/dev/null mkdir tmp 2>/dev/null #******************************************************************************* # FUNCTIONS #******************************************************************************* #------------------------------------------------------------------------------- # DATAFILE SIZE #------------------------------------------------------------------------------- f_get_dfs () { sqlplus -s $s_user/$s_pw as sysdba <<-EOSQL 2> err/${s_myName}_${s_host}_${s_instance}.err SET PAGES 0 SET LINES 150 SET HEADING OFF SET FEEDBACK OFF select round(sum(bytes/1024/1024/1024)) from v\$datafile; quit EOSQL } #******************************************************************************* # MAIN #******************************************************************************* #--- gather general information rm $s_tmpfile 2>/dev/null grep -v '#' /etc/oratab | sed -e's/\:/ /' | awk '{print $1}' | sort | while read s_instance do # done #--- output section cat $s_tmpfile | while read s_line do echo $s_line done #******************************************************************************* # FINE #******************************************************************************* exit