Friday, August 20, 2021
Disk space alert creation script
#!/bin/bash
###########################################################
# This script is to check the space on the Weblogic Mount
###########################################################
CURRENT=$(df /apps | grep / | awk '{ print $5}' | sed 's/%//g')
THRESHOLD=90
if [ "$CURRENT" -gt "$THRESHOLD" ] ; then
mail -s 'Disk Space Alert' XXXXXXXXXXXXX@YYYYYYYY.com << EOF
Your Servername disk remaining free space is critically low. Used: $CURRENT%
EOF
fi
Subscribe to:
Posts (Atom)
SQL executions based on AWR
SQL exection per day SELECT TO_CHAR(s.BEGIN_INTERVAL_TIME, 'YYYY-MM-DD') AS execution_date, ss.SQL_ID, SUM(ss.EXECUT...