ss

Oracle Tips by Burleson

Get the free space limits

This section of the script gathers the minimum allowed free space from our parm_ts_free.ora file. This value will be used to trigger an e-mail alert if the UNIX directory has too little free space.

#*************************************************************
# Here we gather the values from the parm files . . .
#*************************************************************

if [ -f ${ora_unix_home_dir}/mon/parm_ts_free_$ORACLE_SID.ora ]
then
TS_FREE=`cat ${ora_unix_home_dir}/mon/parm_ts_free_$ORACLE_SID.ora`
else
TS_FREE=`cat ${ora_unix_home_dir}/mon/parm_ts_free.ora`
fi

if [ -f ${ora_unix_home_dir}/mon/parm_num_extents_$ORACLE_SID.ora ]
then
NUM_EXTENTS=\
`cat ora_unix_home_dir}/mon/parm_num_extents_$ORACLE_SID.ora`
else
NUM_EXTENTS=`cat ${ora_unix_home_dir}/mon/parm_num_extents.ora`
fi

if [ -f ${ora_unix_home_dir}/mon/parm_mount_point_kb_free_$ORACLE_SID.ora ]
then
KB_FREE=\
`cat {ora_unix_home_dir}/mon/parm_mount_point_kb_free_$ORACLE_SID.ora`
else
KB_FREE=`cat ${ora_unix_home_dir}/mon/parm_mount_point_kb_free.ora`
fi

The above is an excerpt from the "Oracle9i UNIX Administration Handbook" by Oracle press, authored by Donald K. Burleson.

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA