Displaying 1 result from an estimated 1 matches for "limit_valu".
Did you mean:
limit_value
2009 Jan 30
5
Question about Shell Script.
Hi all CentOS users,
I have writing shell script for check oracle processes in real time
and alert with e-mail.
I read script like below
NUMBEROFPRO=/oracle/10.2.0/db_1/bin/sqlplus / as sysdba <<EOF1 |grep
processes|awk '{print $2}'
SELECT resource_name,current_utilization,limit_value FROM
V\$RESOURCE_LIMIT WHERE RESOURCE_NAME IN ('processes','sessions');
quit
EOF1
if [ $NUMBEROFPRO > 150 ]
then
/bin/mail -s "Processes number bigger then 150 !!" myemailadres<<EOF
Contact your system administrator.
EOF
fi
Script print value correctly on scree...