Skip to content

Instantly share code, notes, and snippets.

@travelliu
travelliu / dbalarm
Created December 13, 2015 14:32 — forked from haballan/dbalarm
dbalarm
# #####################################################
# Checking DB & LISTENERS ALERTLOG FOR ERRORS
# Checking CPU, FILESYSTEM, TABLESPACES
# When exceeding the defined THRESHOLD
# Checking BLOCKING SESSIONS ON THE DATABASE
#
# # # #
# Author: Mahmmoud ADEL # # # # ###
# Created: 22-12-13 # # # # #
#
@travelliu
travelliu / dbdailychk.sh
Created December 13, 2015 14:31 — forked from haballan/dbdailychk.sh
Oracle Database Health Check Script
# ##############################################################################################
# DAILY HEALTH CHECK MONITORING SCRIPT
#
# =========================================================
# BECAUSE OF THE PERFORMANCE IMPACT THIS SCRIPT CAN CAUSE,
# I STRONGLY RECOMMEND TO SCHEDULE IT TO RUN IN NON PEAK HOURS
# E.G. SCHEDULE IT TO RUN ONE TIME BETWEEN 12:00AM to 5:00AM
# =========================================================
#
# FEATURES: