Data Object Reference

What is a data object?

Ops Insights Explorer data objects expose highly curated data collected for Ops Insights services into bundles consumable by explorer user interfaces. Raw data collections are post-processed and joined with related entity configuration data dimensions. This facilitates generating powerful result sets from relatively simple queries.
  • Data objects are domain-specific and not necessarily general purpose.
  • Data objects expose their attributes as either dimensions or measures.

Dimension and Measure Attributes

The attributes exposed by data objects are classified as either dimensions or measures.
  • Dimension attributes are typically used to explore various breakdowns of data, by using them in aggregation queries.
  • Measure attributes are typically sourced from observability telemetry reporting numeric instrumentation values from some data source (for instance Oracle internal V$ views.)

The common query pattern encouraged and enabled by explorers is to aggregate measures over dimensions. These are referred to as analytic type queries.

Ops Insights provides the following data objects:

Note

For Exadata Database Service on Dedicated Infrastructure targets, only Exadata Disk Hourly and Exadata Disk Daily data objects are supported.

Top Processes data object will not have data for Enterprise Manager or Cloud Database nodes and/or hosts.

Table 16-1 Available Database Data Objects

Data Object Description
SQL Statistics Daily The SQL Statistics Daily data object is a daily aggregated summary by SQL_ID of numerous execution-level statistics derived from V$SQLSTATS for the most important SQLs to execute during the day.

Used by: SQL Explorer and Data Object Explorer

SQL Stats Summary - Daily The SQL Statistics daily summary data object provides the daily aggregated stats summary for the collected SQLs. It is a streamlined version of the more detailed SQL Stats - Daily data object, focusing on essential metrics and entity details.

Used by: SQL Explorer and Data Object Explorer

Database Load Daily Daily summary of the CPU and IO metrics collected at the database instance.

Used by: Database Explorer and Data Object Explorer

Database Memory Daily Daily summary of the memory metrics collected at the database instance.

Used by: Database Explorer and Data Object Explorer

Database Storage Daily Daily summary for the storage metrics.

Used by: Database Explorer and Data Object Explorer

Database Tablespace Daily Daily summary of the tablespace metrics collected at the database instance.

Used by: Database Explorer and Data Object Explorer

Database Summary Daily Daily summary for CPU, memory, IO and storage metrics, summed over all of the corresponding database's hosts.

Used by: Database Explorer and Data Object Explorer

Database Load Hourly Hourly summary of the CPU and IO metrics collected at the database instance.

Used by: Database Explorer and Data Object Explorer

Database Memory Hourly Hourly summary of the memory metrics collected at the database instance.

Used by: Database Explorer and Data Object Explorer

Database Storage Hourly Hourly summary for the storage metrics.

Used by: Database Explorer and Data Object Explorer

Database Tablespace Hourly Hourly summary of the tablespace metrics collected at the database instance.

Used by: Database Explorer and Data Object Explorer

Database Summary Hourly Hourly summary for CPU, memory, IO and storage metrics, summed over all of the corresponding database's hosts.

Used by: Database Explorer and Data Object Explorer

Database Rollup Delay In Hours Database rollup delay in hours.

Used by: Database Explorer, and Data Object Explorer

MySQL Database System Summary - Daily Daily MySQL Database Systems for CPU, memory, IO and storage metrics, summed over all of the corresponding database's hosts for MySQL Database

Used by: Database Explorer and Data Object Explorer

MySQL Database Summary - Hourly Hourly summary for CPU, memory, IO and storage metrics, summed over all of the corresponding database system's hosts for MySQL Database System

Used by: Database Explorer and Data Object Explorer

MySQL Database System Statements - Daily Daily aggregated summary by digest for the most important statements executed during the day for every database in the database system.

Used by: Database Explorer and Data Object Explorer

Table 16-2 Available Host Data Objects

Data Object Description
Host CPU and Memory Daily Daily summary of the CPU and memory metrics collected at the host.

Used by: Host Explorer and Data Object Explorer

Host CPU and Memory Hourly Hourly summary of the CPU and memory metrics collected at the host.

Used by: Host Explorer and Data Object Explorer

Host Processes Process metrics collected at the host every 60 seconds.

Used by: Host Explorer and Data Object Explorer

Host Rollup Delay In Hours Host metric group rollup delay in hours.

Used by: Host Explorer, and Data Object Explorer

Table 16-3 Available Exadata Data Objects

Data Object Description
Exadata Disk Daily Aggregated storage server (cell) daily summary data for hard and flash disks.

Used by: Exadata Explorer and Data Object Explorer

Exadata Disk Hourly Aggregated storage server (cell) hourly summary data for hard and flash disks.

Used by: Exadata Explorer and Data Object Explorer

Exadata Cell Metric Daily Daily summary of the performance metrics collected at the cell (storage server).

Used by: Exadata Explorer and Data Object Explorer

Exadata Cell Metric Hourly Hourly summary of the performance metrics collected at the cell (storage server).

Used by: Exadata Explorer and Data Object Explorer

Exadata IORM by PDB on Hard Disks Hourly Hourly summary data for IO statistics of IORM by pluggable database on hard disks.

Used by: Exadata Explorer and Data Object Explorer

Exadata IORM by PDB on Hard Disks Daily Daily summary data for IO statistics of IORM by pluggable database on hard disks.

Used by: Exadata Explorer and Data Object Explorer

Exadata IORM by DB on Hard Disks Hourly Hourly summary data for IO statistics of the IORM by database on hard disks.

Used by: Exadata Explorer and Data Object Explorer

Exadata IORM by DB on Hard Disks Daily Daily summary data for IO statistics of the IORM by database on hard disks.

Used by: Exadata Explorer and Data Object Explorer

Exadata IORM by PDB on Flash Disks Hourly Hourly summary data for the IO statistics of the IORM by pluggable database on flash disks.

Used by: Exadata Explorer and Data Object Explorer

Exadata IORM by PDB on Flash Disks Daily Daily summary data for the IO statistics of the IORM by pluggable database on flash disks.

Used by: Exadata Explorer and Data Object Explorer

Exadata IORM by DB on Flash Disks Hourly Hourly summary data for the IO statistics of the IORM by database on flash disks.

Used by: Exadata Explorer and Data Object Explorer

Exadata IORM by DB on Flash Disks Daily Daily summary data for the IO statistics of the IORM by database on flash disks.

Used by: Exadata Explorer and Data Object Explorer

Exadata Summary Daily Daily summary for Exadata system configurations and key aggregated metrics including CPU, memory, hard (physical) disk and flash disk I/O and throughput, and storage.

Used by: Exadata Explorer and Data Object Explorer

Exadata Summary Hourly Hourly summary for Exadata system configurations and key aggregated metrics including CPU, memory, hard (physical) disk and flash disk I/O and throughput, and storage.

Used by: Exadata Explorer and Data Object Explorer

Exadata Rollup Delay In Hours Exadata metric group rollup delay in hours

Used by: Exadata Explorer, and Data Object Explorer

AWR_PDB_* Views The AWR_PDB views show the local Automatic Workload Repository (AWR) data present on a CDB root or a PDB.

The AWR_PDB views can be interchanged with the DBA_HIST views. For example, you can use the AWR_PDB_ACTIVE_SESS_HISTORY view for retrieving the AWR data about the active session history at the PDB level for all the sources registered to the Hub, which is equivalent to the DBA_HIST_ACTIVE_SESS_HISTORY. For detailed per-view list of DBA_HIST* views see: DBA_HIST* Views.

Used by: AWR Hub Explorer