Oracle Enterprise Manager

Oracle Enterprise Manager (Oracle EM) is a distributed application for centralized monitoring of Oracle products.

Oracle EM collects and stores statistics from remote databases, applications, and systems in an Oracle database (SYSMAN.gc$metric_values table) which Axibase Collector queries every 15 minutes to offload incremental data into Axibase Time Series Database for long-term retention and operations analytics.

See OEM integration instructions for technical details.

Oracle Databases Portal:

Launch live Oracle Databases Portal in Axibase Chart Lab.

Oracle Host Portal

Launch live Oracle Host Portal in Axibase Chart Lab.

Collected Oracle Enterprise Manager Metrics

Oracle Databases

oracle_database.archive_area.archive_area_used_%
oracle_database.archive_area.archive_area_used_kb
oracle_database.archive_area.free_archive_area_kb
oracle_database.archive_area.total_archive_area_kb
oracle_database.database_limits.current_logons_count
oracle_database.database_limits.current_open_cursors_count
oracle_database.database_limits.process_limit_usage_%
oracle_database.database_limits.session_limit_usage_%
oracle_database.database_limits.user_limit_usage_%
oracle_database.database_size.allocated_space_gb
oracle_database.database_size.used_space_gb
oracle_database.dump_area.dump_area_used_%
oracle_database.dump_area.dump_area_used_kb
oracle_database.dump_area.free_dump_area_kb
oracle_database.dump_area.total_dump_area_kb
oracle_database.efficiency.buffer_cache_hit_%
oracle_database.efficiency.cpu_usage_per_second
oracle_database.efficiency.cpu_usage_per_transaction
oracle_database.efficiency.cursor_cache_hit_%
oracle_database.efficiency.data_dictionary_hit_%
oracle_database.efficiency.database_cpu_time_%
oracle_database.efficiency.library_cache_hit_%
oracle_database.efficiency.library_cache_miss_%
oracle_database.efficiency.parallel_execution_downgraded_25%_or_more_per_second
oracle_database.efficiency.parallel_execution_downgraded_50%_or_more_per_second
oracle_database.efficiency.parallel_execution_downgraded_75%_or_more_per_second
oracle_database.efficiency.parallel_execution_downgraded_per_second
oracle_database.efficiency.parallel_execution_downgraded_to_serial_per_second
oracle_database.efficiency.parallel_execution_downgraded_to_serial_per_transaction
oracle_database.efficiency.pga_cache_hit_%
oracle_database.efficiency.redo_log_allocation_hit_%
oracle_database.efficiency.response_time_per_transaction
oracle_database.efficiency.row_cache_miss_ratio_%
oracle_database.efficiency.sorts_in_memory_%
oracle_database.flash_recovery.flash_recovery_area_size
oracle_database.flash_recovery.non-reclaimable_flash_recovery_area_%
oracle_database.flash_recovery.reclaimable_flash_recovery_area_%
oracle_database.flash_recovery.usable_flash_recovery_area_%
oracle_database.memory_usage.total_memory_usage_mb
oracle_database.ocm_instrumentation.instrumentation_present
oracle_database.ocm_instrumentation.need_to_instrument_with_ocm
oracle_database.ocm_instrumentation.ocm_configured
oracle_database.recovery_area.recovery_area_free_space_%
oracle_database.scn_growth_statistics.current_scn
oracle_database.scn_growth_statistics.max_rate
oracle_database.scn_growth_statistics.scn_health
oracle_database.scn_growth_statistics.scn_total_growth_rate_per_sec
oracle_database.scn_instance_statistics.scn_intrinsic_growth_rate_per_sec
oracle_database.scn_max_statistics.max_scn_jump_in_one_second_last_24_hours
oracle_database.segment_advisor_recommendations.number_of_recommendations
oracle_database.sga_pool_wastage.java_pool_free_%
oracle_database.sga_pool_wastage.large_pool_free_%
oracle_database.sga_pool_wastage.shared_pool_free_%
oracle_database.system_response_time_per_call.response_time_centi-seconds_per_call
oracle_database.tablespace_allocation.tablespace_allocated_space_mb
oracle_database.tablespace_allocation.tablespace_used_space_mb
oracle_database.tablespaces_full.tablespace_free_space_mb
oracle_database.tablespaces_full.tablespace_space_used_%
oracle_database.throughput.average_active_sessions
oracle_database.throughput.average_synchronous_single-block_read_latency_ms
oracle_database.throughput.bg_checkpoints_per_second
oracle_database.throughput.branch_node_splits_per_second
oracle_database.throughput.branch_node_splits_per_transaction
oracle_database.throughput.consistent_read_blocks_created_per_second
oracle_database.throughput.consistent_read_blocks_created_per_transaction
oracle_database.throughput.consistent_read_changes_per_second
oracle_database.throughput.consistent_read_changes_per_transaction
oracle_database.throughput.consistent_read_gets_per_second
oracle_database.throughput.consistent_read_gets_per_transaction
oracle_database.throughput.consistent_read_undo_records_applied_per_second
oracle_database.throughput.consistent_read_undo_records_applied_per_transaction
oracle_database.throughput.cumulative_logons_per_second
oracle_database.throughput.cumulative_logons_per_transaction
oracle_database.throughput.database_block_changes_per_second
oracle_database.throughput.database_block_changes_per_transaction
oracle_database.throughput.database_block_gets_per_second
oracle_database.throughput.database_block_gets_per_transaction
oracle_database.throughput.database_time_centiseconds_per_second
oracle_database.throughput.dbwr_checkpoints_per_second
oracle_database.throughput.enqueue_deadlocks_per_second
oracle_database.throughput.enqueue_deadlocks_per_transaction
oracle_database.throughput.enqueue_requests_per_second
oracle_database.throughput.enqueue_requests_per_transaction
oracle_database.throughput.enqueue_timeout_per_second
oracle_database.throughput.enqueue_timeout_per_transaction
oracle_database.throughput.enqueue_waits_per_second
oracle_database.throughput.enqueue_waits_per_transaction
oracle_database.throughput.executes_per_second
oracle_database.throughput.executes_performed_without_parses_%
oracle_database.throughput.full_index_scans_per_second
oracle_database.throughput.full_index_scans_per_transaction
oracle_database.throughput.hard_parses_per_second
oracle_database.throughput.hard_parses_per_transaction
oracle_database.throughput.i/o_megabytes_per_second
oracle_database.throughput.i/o_requests_per_second
oracle_database.throughput.leaf_node_splits_per_second
oracle_database.throughput.leaf_node_splits_per_transaction
oracle_database.throughput.network_bytes_per_second
oracle_database.throughput.number_of_transactions_per_second
oracle_database.throughput.open_cursors_per_second
oracle_database.throughput.open_cursors_per_transaction
oracle_database.throughput.parse_failure_count_per_second
oracle_database.throughput.parse_failure_count_per_transaction
oracle_database.throughput.physical_reads_direct_lobs_per_second
oracle_database.throughput.physical_reads_direct_lobs_per_transaction
oracle_database.throughput.physical_reads_direct_per_second
oracle_database.throughput.physical_reads_direct_per_transaction
oracle_database.throughput.physical_reads_per_second
oracle_database.throughput.physical_reads_per_transaction
oracle_database.throughput.physical_writes_direct_lobs_per_second
oracle_database.throughput.physical_writes_direct_lobs_per_transaction
oracle_database.throughput.physical_writes_direct_per_second
oracle_database.throughput.physical_writes_direct_per_transaction
oracle_database.throughput.physical_writes_per_second
oracle_database.throughput.physical_writes_per_transaction
oracle_database.throughput.recursive_calls_per_second
oracle_database.throughput.recursive_calls_per_transaction
oracle_database.throughput.redo_generated_per_second
oracle_database.throughput.redo_generated_per_transaction
oracle_database.throughput.redo_writes_per_second
oracle_database.throughput.redo_writes_per_transaction
oracle_database.throughput.rows_processed_per_sort
oracle_database.throughput.scans_on_long_tables_per_second
oracle_database.throughput.scans_on_long_tables_per_transaction
oracle_database.throughput.session_logical_reads_per_second
oracle_database.throughput.session_logical_reads_per_transaction
oracle_database.throughput.soft_parse_%
oracle_database.throughput.sorts_to_disk_per_second
oracle_database.throughput.sorts_to_disk_per_transaction
oracle_database.throughput.total_index_scans_per_second
oracle_database.throughput.total_index_scans_per_transaction
oracle_database.throughput.total_parses_per_second
oracle_database.throughput.total_parses_per_transaction
oracle_database.throughput.total_table_scans_per_second
oracle_database.throughput.total_table_scans_per_transaction
oracle_database.throughput.user_calls_%
oracle_database.throughput.user_calls_per_second
oracle_database.throughput.user_calls_per_transaction
oracle_database.throughput.user_commits_per_second
oracle_database.throughput.user_commits_per_transaction
oracle_database.throughput.user_rollback_undo_records_applied_per_second
oracle_database.throughput.user_rollback_undo_records_applied_per_transaction
oracle_database.throughput.user_rollbacks_per_second
oracle_database.throughput.user_rollbacks_per_transaction
oracle_database.user_audit.audited_user_session_count
oracle_database.wait_bottlenecks.active_sessions_using_cpu
oracle_database.wait_bottlenecks.active_sessions_waiting:_i/o
oracle_database.wait_bottlenecks.active_sessions_waiting:_other
oracle_database.wait_bottlenecks.average_instance_cpu_%
oracle_database.wait_bottlenecks.host_cpu_utilization_%
oracle_database.wait_bottlenecks.wait_time_%
oracle_database.waits_by_wait_class.average_users_waiting_count
oracle_database.waits_by_wait_class.database_time_spent_waiting_%

Oracle Host

host.cpu_usage.cpu_idle_time_%
host.cpu_usage.cpu_system_time_%
host.cpu_usage.cpu_user_time_%
host.cpu_usage.cpu_utilization_%_of_a_cpu
host.disk_activity_summary.max_average_disk_i/o_service_time_ms_amongst_all_disks
host.disk_activity_summary.max_disk_i/o_per_sec_made_by_a_single_disk
host.disk_activity_summary.total_disk_i/o_made_across_all_disks_per_second
host.file_and_directory_monitoring.file_or_directory_size_change_rate_kb/minute
host.file_and_directory_monitoring.file_or_directory_size_mb
host.filesystems.filesystem_size_mb
host.filesystems.filesystem_space_available_%
host.filesystems.filesystem_space_available_mb
host.load.active_logical_memory_kilobytes
host.load.active_memory_kilobytes
host.load.cpu_in_i/o_wait_%
host.load.cpu_in_system_mode_%
host.load.cpu_in_user_mode_%
host.load.cpu_utilization_%
host.load.free_memory_%
host.load.logical_free_memory_%
host.load.memory_page_scan_rate_per_second
host.load.memory_utilization_%
host.load.run_queue_length_15_minute_average_per_core
host.load.run_queue_length_1_minute_average_per_core
host.load.run_queue_length_5_minute_average_per_core
host.load.swap_utilization_%
host.load.total_processes
host.load.total_users
host.load.used_logical_memory_%
host.network_interfaces.network_interface_collisions_%
host.network_interfaces.network_interface_combined_utilization_%
host.network_interfaces.network_interface_input_errors_%
host.network_interfaces.network_interface_output_errors_%
host.network_interfaces.network_interface_read_mb/s
host.network_interfaces.network_interface_read_utilization_%
host.network_interfaces.network_interface_total_error_rate_%
host.network_interfaces.network_interface_total_i/o_rate_mb/sec
host.network_interfaces.network_interface_write_mb/s
host.network_interfaces.network_interface_write_utilization_%
host.network_interfaces_summary.all_network_interfaces_combined_utilization_%
host.network_interfaces_summary.all_network_interfaces_read_rate_mb/sec
host.network_interfaces_summary.all_network_interfaces_read_utilization_%
host.network_interfaces_summary.all_network_interfaces_total_i/o_rate_mb/sec
host.network_interfaces_summary.all_network_interfaces_write_rate_mb/sec
host.network_interfaces_summary.all_network_interfaces_write_utilization_%
host.paging_activity.active_pages
host.paging_activity.pages_paged-in_per_second
host.paging_activity.pages_paged-out_per_second
host.paging_activity.pages_scanned_by_page_stealing_daemon_per_second
host.program_resource_utilization.program_s_max_cpu_time_accumulated_minutes
host.program_resource_utilization.program_s_max_cpu_utilization_%
host.program_resource_utilization.program_s_max_process_count
host.program_resource_utilization.program_s_max_resident_memory_mb
host.program_resource_utilization.program_s_min_process_count
host.program_resource_utilization.program_s_total_cpu_time_accumulated_minutes
host.program_resource_utilization.program_s_total_cpu_utilization_%
host.storage_summary.asm_storage_allocated_gb
host.storage_summary.asm_storage_metric_collection_errors
host.storage_summary.asm_storage_overhead_gb
host.storage_summary.asm_storage_unallocated_gb
host.storage_summary.databases_storage_free_gb
host.storage_summary.databases_storage_metric_collection_errors
host.storage_summary.databases_storage_used_gb
host.storage_summary.disk_storage_allocated_gb
host.storage_summary.disk_storage_unallocated_gb
host.storage_summary.host_storage_metric_collection_errors
host.storage_summary.host_summarized
host.storage_summary.local_file_systems_storage_free_gb
host.storage_summary.local_file_systems_storage_used_gb
host.storage_summary.number_of_asm_instances_summarized
host.storage_summary.number_of_databases_summarized
host.storage_summary.other_mapping_errors
host.storage_summary.total_number_of_asm_instances
host.storage_summary.total_number_of_databases
host.storage_summary.total_storage_allocated_gb
host.storage_summary.total_storage_free_gb
host.storage_summary.total_storage_overhead_gb
host.storage_summary.total_storage_unallocated_gb
host.storage_summary.total_storage_used_gb
host.storage_summary.unmonitored_nfs_server_mapping_errors
host.storage_summary.volumes_storage_allocated_gb
host.storage_summary.volumes_storage_overhead_gb
host.storage_summary.volumes_storage_unallocated_gb
host.storage_summary.writeable_nfs_storage_free_gb
host.storage_summary.writeable_nfs_storage_used_gb
host.total_disk_usage.total_disk_available_%__across_all_local_filesystems
host.total_disk_usage.total_disk_size_across_all_local_filesystems_in_mb
host.total_disk_usage.total_disk_space_available_across_all_local_filesystems_in_mb
host.total_disk_usage.total_disk_space_utilized_across_all_local_filesystems_in_mb
host.total_disk_usage.total_disk_utilized_%__across_all_local_filesystems
host.zombie_processes.processes_in_zombie_state_%