Skip to content
English
Submit a support ticket
Back to www.opslogix.com
  • There are no suggestions because the search field is empty.

Oracle Management Pack: tasks, views, dashboards and reports

An overview of the views, dashboards, reports and tasks that the Opslogix Oracle Management Pack adds to the SCOM console.

Applies to: Opslogix Oracle Management Pack (all versions)
Last updated: October 2026 · Latest version: 26.4.4517.0

See also: Upgrade guide for 26.4.4517.0 · Version support · Release notes

Views (Monitoring pane)

  • Instance state, instance performance and a diagram view from each instance down to its tablespaces, data files, redo logs, control files and backups.
  • State views for tablespaces, temp tablespaces, temp data files, redo log groups, redo log files and backups, and an alert view for backups.
  • With the Data Guard pack: state views for primary and standby databases and a Data Guard performance view.
  • State and alert views for the Opslogix Oracle Collector service.

Dashboards

  • Instance dashboard: 24-hour trends of active user sessions, SQL cache hit ratio and buffer hit ratio, with top-N lists of the instances with the most sessions and the lowest hit ratios.
  • Memory dashboard: 24-hour trends and top-N lists of free memory in the shared pool and the large pool.
  • Storage dashboard: top 10 tablespaces by usage %, the 10 tablespaces and temp tablespaces with the least free space, top 10 average I/O read times, and a 24-hour trend of free space.
  • Oracle IMP Configuration Dashboard (Administration pane): add, test and remove Oracle instances, assign licenses and bulk import/export instances.

Reports (Reporting pane)

The Oracle Reports management pack adds 19 reports, based on the SCOM data warehouse:

  • Instance and tablespace dashboard reports.
  • Availability reports for the instance, with the availability, configuration, performance and security health roll-ups.
  • Performance reports for buffer hit ratio, SQL cache hit ratio, sessions, and tablespace free space (MB and %).
  • Matrix reports for buffer usage, memory usage, sessions and tablespace usage.
  • A top-N report for active user sessions.

The matrix reports need the "OpsLogix IMP Generic Reports" management pack, which is included in the release.

Tasks

  • OpsLogix Oracle TestConnection: tests the connection to an Oracle instance from the resource pool.
  • Query TOP 10 Querys By CPU: shows the ten SQL statements that use the most CPU on an Oracle instance.
  • OpsLogix Deploy Oracle Collector Task: deploys the Opslogix Oracle Collector to all members of the selected SCOM resource pool.