PREVIOUS Inventory events

Performance

Devo allows you to monitor the performance metrics. The basic performance metrics are:

  • database file I/O performance
  • Oracle system performance
  • Oracle library cache performance
  • host OS performance

Oracle system performance collects many performance metrics, including cache hit ratio, database CPU performance, network traffic, SQL service response time, and Oracle Physical and Logical I/O stats. Oracle Database administrators or Devo Admin users can create performance trending dashboards or alerts.

The table below provides the default location for each log file and the query you can run in case location has changed.

Log format Oracle version Tags Default file location
CSV 10g/11g/12c (Linux and Windows)

oracle.dbFileIoPerf

oracle.sysPerf

oracle.osPerf

oracle.libraryCachePerf

oracle.cpuLoadPerf

oracle.dbIoPerf

oracle.memPerf

oracle.networkPerf

oracle.readwrite

oracle.avgExecutions

N/A
Key=Value 10g/11g/12c (Linux and Windows)

oracle.connections

oracle.pool.connections

oracle.database

oracle.database.size

oracle.table

oracle.user

oracle.query

oracle.session

N/A

This table lists the CIM and ITSI data models for each source type. 

Tags

CIM Data Models

ITSI Data Models

oracle.dbFileIoPerf

None

None

oracle.sysPerf

Databases data model object:

  • All_Databases

Database data model object:

  • Performance

oracle.osPerf

None

None

oracle.libraryCachePerf

None

None

oracle.connections

Databases data model object:

  • All_Databases

Database data model object:

  • Performance

oracle.pool.connections

Databases data model object:

  • All_Databases

Database data model object:

  • Performance

oracle.database.size

Databases data model object:

  • All_Databases

Database data model object:

  • Performance

oracle.table

None

Database data model object: Table

oracle.user

Databases data model object:

  • All_Databases

Database data model object:

  • User

oracle.query

Databases data model object:

  • Database_Query

Database data model object:

  • Query

oracle.session

None

Database data model object:

  • Session

oracle.cpuLoadPerf

Performance data model object:

  • CPU

None

oracle.dbIoPerf

Performance data model object:

  • Storage

None

oracle.memPerf

Performance data model object:

  • Memory

None

oracle.networkPerf

Performance data model object:

  • Network

None

oracle.readwrite

Databases data model object:

  • All_Databases

Database data model object:

  • Performance

oracle.avgExecutions

Databases data model object:

  • All_Databases

None

Have we answered your question?

If not, please contact our technical support team via email by clicking the button below.

CONTACT US

PREVIOUS Inventory events