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.

Launch
Oracle Host Portal

Launch live Oracle Host Portal in Axibase Chart Lab.

Launch

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_%