Using Data Object Explorers
From the a data object explorer page, you can begin exploring performance information about your monitored resources. The following graphic illustrates the functional regions of the UI in both Basic and Advanced mode.
| Region | Description |
|---|---|
| 1 | Resource type, Data object, Compartment, and time range selectors: Allow you to set the scope of your session by selecting . |
| 2 | Attributes list: Select the attributes you're interested in exploring and add them to the query. |
| 3 | Query text entry: Manually enter the query to extract data you're interested in. The type-ahead feature helps you construct the query by providing in-context values. |
| 4 | Query results/raw data: All data returned by the query in tabular format. |
| 5 | Visualization center: Manipulate the raw data into an intuitive visualization. |
| 6 | Action menu: Save/Save as/Open/Create New/Delete a SQL query.
Mode: Allows you to select between Basic and Advanced SQL query creation mode. |
The following illustration shows the SQL Explorer UI with Basic SQL query editor selected. In this mode the SQL query is created with a SELECT statement you construct, this has a limited function query optimized to run against the selected data object and extract the most useful data with minimal complexity. Full range of SQL SELECT statement operations will not be compatible with the data object explorers and will generate an error when run. The UI guides you through SELECT statement creation.
The following illustration shows the SQL Explorer UI with Advanced query editor selected. In this mode the SQL query box is shown as a free-text editor allowing you to create SELECT SQL queries of your own design, standard SQL SELECT statement operations are available in this mode.