Oracledb_Dashboard_202210
1,104

Created 10/7/2022
Updated 10/15/2022
Revision 1
Categories
Databases
Grafana Version >=8.4.0
Datasources
Prometheus

Description

Oracle dashboard monitors db status, active sessions, user commits, wait times and more.

Screenshots

Source Grafana.com

Used Metrics 40

  • interval

  • oracledb_dataguard_exist_value

  • oracledb_dataguard_status_value

  • oracledb_db_recovery_file_dest_percent_space_used

  • oracledb_db_recovery_file_dest_value

  • oracledb_env_is_rac

  • oracledb_env_redo_switch_value

  • oracledb_env_redo_value

  • oracledb_env_running_time

  • oracledb_env_value

  • oracledb_env_version

  • oracledb_env_vols

  • oracledb_events_value

  • oracledb_parameter_sessions_value

  • oracledb_parameter_value

  • oracledb_rman_info_value

  • oracledb_rman_status_value

  • oracledb_sessions_value

  • oracledb_sysmetric_buffer_cache_hit_ratio

  • oracledb_sysmetric_database_time_per_sec

  • oracledb_sysmetric_library_cache_hit_ratio

  • oracledb_sysmetric_logical_reads_per_sec

  • oracledb_sysmetric_logons_per_sec

  • oracledb_sysmetric_memory_sorts_ratio

  • oracledb_sysmetric_pga_cache_hit_

  • oracledb_sysmetric_physical_read_total_bytes_per_sec

  • oracledb_sysmetric_physical_read_total_io_requests_per_sec

  • oracledb_sysmetric_physical_write_total_bytes_per_sec

  • oracledb_sysmetric_physical_write_total_io_requests_per_sec

  • oracledb_sysmetric_redo_allocation_hit_ratio

  • oracledb_sysmetric_redo_generated_per_sec

  • oracledb_sysmetric_redo_writes_per_sec

  • oracledb_sysmetric_row_cache_hit_ratio

  • oracledb_sysmetric_user_transaction_per_sec

  • oracledb_sysstat_bytes_received_via_sqlnet_from_client

  • oracledb_sysstat_bytes_sent_via_sqlnet_to_client

  • oracledb_tablespace_bytes

  • oracledb_tablespace_free

  • oracledb_tablespace_max_bytes

  • oracledb_up

Get Dashboard
Download
Copy to Clipboard