Checklist Item
Daily
DB Availability
DPA Alert : DB1 Availability
Triggered when it's unable to establish a connection to the database
Email : FAILED login to DB within 30 second timeout AND/OR very slow DB
DB performance
Ignite (DPA)
Ignite (DB WAITS) - Watch for unusual trends in the default displayed 30 days (including Explain Plan changes) and check the "RESOURCES" section.
DB growth
Email : Database Growth Report
Checking for Top 10 Growing Schemas, Top 10 Growing Schema Objects, Top 10 Growing Database Objects
DB Tablespace usage
EARLY WARNING: DB Tablespace Usage (oracle)
EARLY WARNING: DB Tablespace Usage (oracle) -Fridays
DB TEMP Tablespace Usage (oracle)
Top CPU
Email : DB Top CPU Consumers
Monitor Top CPU processes
Memory
Email : DB Top Memory Consumers
Server Memory, PGA Usage, Memory Utilization (Top processes)
Email : WARNING: PROD DB PGA memory used =
Total usage for PGA memory used > 76100MB
Email ERROR: PGA Limit Alert for DB1
Index
Email : DB1 Checking Unusable Indexes
Checking global Indexes and partition indexes in unusable state
Session