Oracle Cloud Infrastructure Documentation

Overview of Resource Analytics

OCI Resource Analytics is an inventory of OCI resources, their relationships, and configuration metadata.

You can access near-real-time, detailed information on monitored resources with SQL queries, graph-based visualizations, and analytics dashboards. Resource Analytics provisions Autonomous Data Warehouse (ADW) and, optionally, an Oracle Analytics Cloud (OAC) instance in your tenancy, letting you import datasets and dashboards to track the inventory, monitor compliance, and troubleshoot. The ADW maintains a best-practice relational model of OCI resources, including a property graph that lets you analyze resources and their associations in Graph Studio, and continuously ingests resource updates across the regions and tenancies you specify.
Important

Resource Analytics requires an ADW instance, and optionally an OAC instance. Although the resource updates provided by Resource Analytics are free, use of ADW (and OAC) is chargeable.
Altogether, you have:
Direct SQL connections
All the existing interfaces for connecting to an Autonomous Data Warehouse are available.
Built-in analytics
An optional preconfigured Oracle Analytics Cloud (OAC) instance with a semantic model, along with prebuilt dashboards and reports.
Third-party data integration
You can bring custom datasets by importing the data into a separate schema in ADW. Then, you can merge these custom datasets with Resource Analytics datasets for enriched insights.
Visualization
Intuitive graph visualization enabled through Graph Studio with preconfigured maps and notebooks to explore resources and their interdependencies.

About Resource Analytics Releases

Learn about the releases for Resource Analytics.

Release 1.0
Subject Areas
New Features
Feature Description
NLB Enhanced NLB Subject Area to have fact metrics at each level. Listener, Backends, Health Checker and NLB and allow analyzing across different dimensions.
LBaaS Enhanced LBaaS Subject Area to have fact metrics at each level. Listener, Backends, Health Checker and LBaaS and allow analyzing across different dimensions.
Compute Added new dimensions block boot volume, Vlan, Vnic, and subnet dimensions.
DBaaS Exadata Added OCPUs Enabled Count metric to Dbaas Exadata Cluster Fact.
DBaaS ADB Added Lifecycle State and VM Name to Autonomous Virtual Machine.
Tags Available in OAC to analyze, summarize, and visualize Tags data.
DbaaS Backup Available in OAC to analyze, summarize, and visualize Databases and Backup related data.
Resource URL Attribute Resource URL attribute in the presentation tables in all the subject areas.
Reports and Workbooks
New Features
Feature Description
NLB Dashboard Canned content workbook and reports for summarizing and visualizing Load Balancer Resources.
LBaaS Dashboard Canned content workbook and reports for summarizing and visualizing Load Balancer Resources
Resource Discovery Dashboard > Accounts Canvas Accounts canvas for Subscription and Compartment information reporting.
Resource Discovery Dashboard > Tags and Associated Resource Details Tags and Associated Resources Detail canvas displaying the tags associated with the resource.
Resource Discovery Dashboard > Resources without Tags Resources without Tags for displaying all the resources which doesn't have tags information.
Resources Discovery Dashboard > Resources Drill Down Report Hyperlink to select the resource ID opens up the OCI Console page for the current resource.
Compute Infrastructure Dashboard > Compute Instances and Associated Tags Details Compute Instances and Associated Tags Details canvas displaying the tags information for the compute instances.
OCI DBaas Inventory > DB Resources and Associated Tags DB Resources and Associated Tags canvas displaying the tags information for the Database resources.
View data in ADW regarding your Block Volume, Compute, Database, Load Balancer, and Networking Resources Connect to ADW to access views and write SQL queries to see details about your Block Volume, Compute, Database, Load Balancer and Networking Resources.
Added new Subject Areas and enhanced the existing ones

Addition of Tags and DBaaS Backup subject Area to OAC. Enhanced NLB and LBaaS Subject Area to have fact metrics.

Added new dimensions: block boot volume, vlan, vnic and subnet to Compute Subject Area.

DBaaS Subject area now has OCPUs Enabled Count metric to Dbaas Exadata Cluster Fact.

DBaaS ADB has Lifecycle State and Vm Name to Autonomous Virtual Machine.
Addition of new Associations, Attributes and Paragraphs

Base Database Backup Association now available in OCIRA DBaaS Explorer for visualizing backup(Base Database Backup) relationships.

Subnet and Load Balancer Association now available in OCIRA Network Explorer for enhanced network relationship visibility.

A new paragraph has been introduced in the Network Explorer notebook offering a unified view of the associations between a subnet and its connected Databases, alongside the relationships between the subnet and Compute instances.

All Notebooks now include a Resource URL for quick navigation to OCI Console.

Added Lifecycle State and Virtual Machine Name to Autonomous Virtual Machine Vertex.
Graph
New Features
Category Feature
Base Database Backup Association Available in DBaaS Explorer for visualizing backup (Base Database Backup) relationships.
New Attributes in Autonomous VM Vertex Added Lifecycle State and Virtual Machine Name to Autonomous Virtual Machine Vertex.
Subnet and Load Balancer Association Available in Network Explorer for enhanced network relationship visibility.
Resource URL Attribute in Notebooks Added Resource URL to all notebooks for quick navigation to OCI Console (requires sign in).
Unified view for compute and databases A new paragraph has been introduced in the Network Explorer notebook offering a unified view of the associations between a subnet and its connected databases, alongside the relationships between the subnet and Compute instances.

Billing Metrics of Autonomous Data Warehouse Associated with Resource Analytics

Resource Analytics requires an ADW instance, and optionally an OAC instance.

Although the resource updates provided by Resource Analytics are free, use of ADW and OAC is chargeable:

About the Resource Analytics Console

The Resource Analytics Console has several functions.

The functions are:

  • Setting up a Resource Analytics instance.
  • Changing existing Resource Analytics instances (such as regional or tenancy coverage).
  • Listing existing Resource Analytics instances.
  • Choosing to change Resource Analytics feature selection (for example, adding OAC).
  • Removing an Resource Analytics instance or optional components.
    Note

    The removal of a Resource Analytics instance doesn't delete the Oracle ADW instance or the data contained within it, nor is any OAC removed. But, the remaining data becomes stale as the update feeds are removed. To remove the ADW or optional OAC instance, follow instructions provided in the appropriate Console management applications for these services.

The Resource Analytics Console can be found by navigating within the Console menu to the section entitled Observability & Management. From the list of services, select Resource Analytics to take you to the main landing page for the service. From here you can either create a new instance or view any instances created earlier.

Bring Your Own License (BYOL)

Resource Analytics is powered by Oracle Database Enterprise Edition, and optionally Oracle Analytics Cloud (OAC). These tools are provisioned and tuned for use with Resource Analytics as part of the Resource Analytics provisioning process. However, you may select a BYOL option for both the database and OAC to bring your existing software licenses to the cloud service, if they're available. Note that Resource Analytics requires Oracle Database Enterprise Edition.

To use BYOL, select this option while completing the Resource Analytics create instance form.

Oracle Database

Resource Analytics is powered by Oracle's Autonomous Data Warehouse and defaults to version 23ai (if this version is available in the realm or region you're deploying in). If version 23ai isn't available, version 19c is provisioned instead. Details on the database and version provisioned can be found in the Oracle Database Console application.

You need to provide some basic information to let Resource Analytics provision the required ADW instance: the network to be used (VNC and subnet), and either an administrator password or details of an appropriate secret contained within your OCI vault.
Note

The standard configuration uses 4 ECPUs and 1 TB of storage and is set to scale automatically.
If a text-based password is supplied, the username can't be changed, but you're free to enter any valid ADW password. (The specification for this password is 12 to 30 characters, containing at least one uppercase letter, one lowercase letter, and one numeric value. Spaces aren't allowed.)
Note

Any password provided is only used for protected steps in the provisioning process and is then immediately removed and not stored by Resource Analytics.
You're free to change the password in the ADW service Console when ADW has completed provisioning.

Starting and Stopping the ADW: Implications for Resource Analytics

ADW is a critical component of the Resource Analytics instance. Stopping or disabling the database has direct implications on the functionality and data freshness of your Resource Analytics setup.

What Happens When the Autonomous Database is Stopped?

  • Live updates are paused
    The Resource Analytics instance stops receiving real-time updates related to resource changes.
    The instance state changes to Needs Attention
    This indicates that user action is needed.

How to Recover

Re-enable or re-start the ADW instance to resolve the issue. When it's active, the Resource Analytics pipeline resumes processing updates within an hour.
Note

Consider the following:
Backfill delay
On ADW restart, the processing and ingesting any accumulated (pending) data events - a process known as backfill - might take extra time to complete. As a result, you might experience delays in data refresh and availability within the system.
Impact of extended downtime
If the ADW instance remains shut down for an extended period, the duration required to backfill pending events increases proportionally.
Automatic ingestion suspension
If the ADW instance is offline for more than 21 consecutive days, automatic data ingestion is permanently disabled for the associated Resource Analytics instance. At this point:
  • The affected Resource Analytics is marked as obsolete.
  • The only solution available is to delete the obsolete Resource Analyticsinstance and create a new one.
Plan the maintenance activities to minimize data pipeline disruption and ensure continued service availability.

Oracle Analytics Cloud

Oracle Analytics Cloud (OAC) is a popular tool for visualizing Oracle database data. Resource Analytics provides sample dashboards for Resource Analytics data that can be accessed in an OAC instance. To use OAC as part of your Resource Analytics, select the box to provision a new instance with the sample dashboards included automatically.

After you have decided to provision OAC, two further options must be considered:

  • Bring Your Own License (BYOL)

    If your organization already owns licenses for OAC it's possible to allocate one of those for use with Resource Analytics. Select the BYOL option when creating your instance or when adding OAC to an existing instance.

  • Choice of Network Configuration

    By default you're assigned a public endpoint through which to access the OAC instance. To configure OAC for a Private Endpoint, select the relevant option on the create form. For more information, see: Do You Need a Public or Private Endpoint?.

    Note

    The endpoint type for OAC can't be changed after it's selected.
    For information on using Resource Analytics with OAC, see Using OAC with Resource Analytics.