Data Object Reference
What is a data object?
- Data objects are domain-specific and not necessarily general purpose.
- Data objects expose their attributes as either dimensions or measures.
Dimension and Measure Attributes
- 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:
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 17-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 17-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 17-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 |