Disclaimer:
This script is provided for educational and learning purposes. Review it carefully,
test in a non-production environment, confirm privileges, and validate impact before
using it in production.
PROMPT Running Daily DBA Health Checks...
@daily_dba/01_instance_and_database_status.sql
@daily_dba/02_tablespace_usage.sql
@daily_dba/03_datafiles_autoextend_capacity.sql
@daily_dba/04_invalid_objects_by_owner.sql
@daily_dba/05_blocking_and_blocked_sessions.sql
@daily_dba/06_long_running_operations.sql
@daily_dba/07_failed_scheduler_jobs_last_24h.sql
@daily_dba/08_archivelog_generation_last_24h.sql
@daily_dba/09_temp_usage_by_session.sql
@daily_dba/10_stale_optimizer_stats.sql
@daily_dba/11_undo_tablespace_usage_and_retention_cdb_root_only.sql
@daily_dba/12_undo_active_transactions.sql
@daily_dba/13_temp_tablespace_usage_summary.sql
@daily_dba/15_redo_log_switches_by_hour_rac.sql