Data Object Explorers

Ops Insights data object explorers provide an easy-to-use interface that lets you interactively explore and visualize detailed performance statistics stored in Ops Insights SQL Warehouse.

A data object explorer allows you to explore performance statistics via a SQL query to extract the data with which to create an intuitive visualization. The query is run against data objects, which are essentially curated views on top of the collected Ops Insights metrics. Ops Insights provides different explorers, each defined by the data object(s) they can access:

Data Object Explorer	Data Object
SQL Explorer	SQL Statistics Daily
Database Explorer	Database Load Daily Database Memory Daily Database Storage Daily Database Tablespace Daily Database Summary Daily Database Load Hourly Database Memory Hourly Database Storage Hourly Database Tablespace Hourly Database Summary Hourly
Host Explorer	Host CPU and Memory Daily Host CPU and Memory Hourly Host Processes
Exadata Explorer Note For Exadata Database Service on Dedicated Infrastructure targets, only Exadata Disk Hourly and Exadata Disk Daily data objects are supported. Exadata IORM Dashboard - Hourly is not supported for Exadata Database Service on Dedicated Infrastructure targets monitored via Private Endpoint.	Exadata Disk Hourly Exadata Disk Daily Exadata Cell Metric Daily Exadata Cell Metric Hourly Exadata IORM by DB on Flash Disks Daily Exadata IORM by DB on Flash Disks Hourly Exadata IORM by DB on Hard Disks Daily Exadata IORM by DB on Hard Disks Hourly Exadata IORM by PDB on Flash Disks Daily Exadata IORM by PDB on Flash Disks Hourly Exadata IORM by PDB on Hard Disks Daily Exadata IORM by PDB on Hard Disks Hourly
Data Object Explorer	All data objects listed above.
AWR Hub Explorer	AWR_PDB* Views

A data object explorer UI simplifies constructing a SQL SELECT statement by allowing you to select columns from an attributes list. Alternatively, you can enter SQL manually. The type-ahead feature lets you enter SQL for the query and SQL Explorer automatically provides inline drop-down list of attribute columns to complete the statement. Run the SQL query to extract raw data. You view the raw data returned by the constructed SQL SELECT query and then use this data to create an intuitive visualization that’s easy to consume and draw inferences from.

Oracle Cloud Infrastructure Documentation