Scripts

These are a few of the scripts I use on a daily basis. Some of them are mine, while others are from the community. I hope they help you.

All of them can also be downloaded directly from my  Github.

ASM

asm_check_databases_per_diskgroup.sql

asm_check_diskgroup_compatibility.sql

asm_check_diskgroup_conf.sql

asm_check_free_space.sql

asm_check_griddisks.sql

asm_rebalance_operation.sql

Backup

rman_backup_job_details.sql

rman_last_backup_taken.sql

Data Guard

dg_check_apply_lag.sql

dg_check_standby_status.sql

dg_check_standby_status_detailed.sql

Database Jobs

check_auto_tasks.sql

dba_jobs_list.sql

dba_jobs_running.sql

dba_scheduler_jobs_history.sql

dba_scheduler_jobs_list.sql

dba_scheduler_jobs_running.sql

MViews

mview_kill_refresh_mview.sql

mview_mlog_details.sql

mview_refresh_time_metrics.sql

mviews_being_refreshed.sql

mviews_with_delay.sql

Memory

mem_buffer_cache_adv.sql

mem_pga_adv.sql

mem_pga_usage.sql

mem_sga_adv.sql

mem_sga_dyn_comp.sql

mem_sga_info.sql

mem_shared_pool_adv.sql

Miscellaneous

cdb_current_name.sql

check_pdbs_details.sql

find_segment_by_blockid.sql

license_usage_statistics.sql

ls_fks_and_their_pks.sql

ls_fra_space.sql

ls_hidden_params.sql

ls_params_non_default.sql

obj_invalid.sql

os_metris_from_db.sql

Monitoring

README.md

alert_backup_last_24_hours.sql

alert_check_audition_size.sql

alert_dbs_failed_jobs.sql

alert_dbs_invalid_objects.sql

alert_dbs_slow.sql

alert_dbs_workload.sql

alert_dg_lag.sql

alert_instance_hit_ratio_buffer_cache.sql

alert_instance_hit_ratio_library_cache.sql

alert_instance_process_limiit.sql

alert_mviews_delay.sql

alert_os_load_from_db.sql

alert_redo_pct_used.sql

alert_sequences_threshold.sql

alert_session_active_long_running.sql

alert_sessions_limit.sql

alert_sessions_locks.sql

alert_stats_missing.sql

alert_statspack_old_snaps.sql

alert_tbs_temp_usage.sql

alert_tbs_undo_usage.sql

alert_tbs_usage_pct.sql

alert_users_to_expire.sql

display_dbs_compatible.sql

display_dbs_cpus.sql

display_dbs_edition.sql

display_dbs_growth.sql

display_dbs_is_archivelog.sql

display_dbs_role.sql

display_dbs_size.sql

display_dbs_startup_time.sql

display_dbs_version.sql

display_dg_is_configured.sql

display_instance_logical_r_ps.sql

display_instance_number.sql

display_instance_physical_r_ps.sql

display_instance_physical_w_ps.sql

display_instance_status.sql

display_sessions_active.sql

display_sessions_logons_ps.sql

display_sessions_response_time.sql

display_transactions_number.sql

Performance

calc_optimizer_index_cost_adj.sql

query_dml_monitored.sql

query_execution_time_history.sql

query_fts_sql.sql

query_histograms.sql

sql_bind_capture.sql

Security

check_ace.sql

check_acl.sql

ls_proxy_users_connected.sql

report_role_permissions.sql

report_user_permissions.sql

user_tbs_quotas.sql

Sessions

kill_sessions.sql

ls_users.sql

session_current_details.sql

session_current_sid.sql

sessions_active.sql

sessions_blocking.sql

sessions_cnt_x_profile.sql

sessions_lock_tree.sql

sessions_longops.sql

sessions_parallel.sql

Statistics

stats_check_db_pref.sql

stats_check_schema_pref.sql

stats_check_tab_gather_history.sql

stats_check_tab_pref.sql

stats_history_available.sql

stats_history_retention.sql

stats_missing.sql

Tablespaces, Datafile and Redos

ls_database_size.sql

ls_datafiles.sql

ls_tablespaces.sql

ls_tempfiles.sql

redo_log_frequency_map.sql

redo_log_stats.sql

tbs_blocksize.sql

tbs_free_space.sql

tbs_temp_pct_usage.sql

tbs_temp_top_consumers.sql

tbs_undo_usage_cdb.sql

tbs_undo_usage_non-cdb.sql