Oracle Database Health Check Script
This script performs a general database health check by executing multiple monitoring scripts and spooling the output to a report file. It connects to the database, runs several diagnostic scripts (database info, sessions, tablespace usage, and extent checks), and generates a consolidated health report.
oraclesqlmonitoring-alertsv1.0.0
0 stars0 downloads18 views0 comments
By OracleDba • Created
Code
(17 lines)1234567891011121314151617
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/health.sql
-- Author : Tim Hall
-- Description : Lots of information about the database so you can asses the general health of the system.
-- Requirements : Access to the V$ & DBA views and several other monitoring scripts.
-- Call Syntax : @health (username/password@service)
-- Last Modified: 15/07/2000
-- -----------------------------------------------------------------------------------
SPOOL Health_Checks.txt
conn &1
@db_info
@sessions
@ts_full
@max_extents
SPOOL OFF