Ops Insights allows you to analyze all (database, host, and Exadata) resources across an entire compartment hierarchy, letting you perform comprehensive fleet-wide analysis.

Cross-compartment data access allows you to gather insights at the root or parent compartment level: Resources residing at all sub-levels can be aggregated for more meaningful fleet analysis. For example, a corporate parent compartment contains two primary sub-compartments (Finance and Human Resources), each with its own database. Additionally, both Finance and Human Resources compartments have sub-compartments with their own databases. You're interested in all databases belonging to the Finance department due to excessive CPU usage. You can select the top-level Finance compartment and then use Capacity Planning to compare CPU utilization between databases residing within the Finance compartment hierarchy.

Cross-compartment resource access lets you:

• Analyze all resources within a given region for the entire tenancy
• Respect current authorization policies by authorizing the highest compartment as part of the authorization decision
• Analyze all resources within a given compartment subtree

Select the desired compartment under Scope and click the Include child compartments option to activate cross-compartment access.