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

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...