PREVIOUS Trace log

NEXT Performance

Inventory events

Devo allows you to query for inventory events. The critical inventories are:

  • Oracle instance
  • database
  • session
  • SGA information
  • tablespace
  • tablespace usage

Oracle Database administrators can do event correlation between the inventories with other trace/audit events and performance metrics and view all the database instances and their metrics in one central place. 

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

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

oracle.instance

oracle.database

oracle.session

oracle.sga

oracle.tablespace

oracle.tablespaceMetrics

oracle.instanceReadWrite

N/A

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

Tags

CIM Data Models

ITSI Data Models

oracle.instance

Databases data model object:

  • All_Databases

Database data model objects:

  • Inventory

oracle.instanceReadWrite

Databases data model object:

  • All_Databases

None

oracle.database

Databases data model object:

All_Databases

None

oracle.session

Databases data model object:

  • All_Databases

Database data model object:

  • Session

oracle.sga

Databases data model object:

  • All_Databases

None

oracle.table

Databases data model object:

  • All_Databases

Database data model object:

  • Table

oracle.tablespace

None

None

oracle.tablespaceMetrics

Databases data model object:

  • Tablespace

Performance data model object:

  • Storage

Database data model objects:

  • Query

Have we answered your question?

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

CONTACT US

PREVIOUS Trace log

NEXT Performance