• Getting Started
  • Oracle Cloud Infrastructure Cloud Adoption Framework
  • Oracle Cloud's Free Tier
  • Oracle Multicloud
  • Oracle Cloud Infrastructure Government Cloud
  • Oracle EU Sovereign Cloud
  • Applications Services
  • Infrastructure Services
    • Service Essentials
    • Access Governance
    • Analytics Cloud
    • Anomaly Detection
    • API Gateway
    • Application Dependency Management
    • Application Performance Monitoring
    • Archive Storage
    • Artifact Registry
    • Audit
    • Automated CEMLI Execution
    • Autonomous Linux
    • Bastion
    • Big Data Service
    • Billing and Cost Management
    • Block Volume
    • Blockchain Platform
    • Certificates
    • Cloud Advisor
    • Cloud Guard
    • Cluster Placement Groups
    • Compartment Quotas
    • Compliance Documents
    • Compute
    • Compute Cloud@Customer
    • Connector Hub
    • Console Dashboards
    • Container Instances
    • Container Registry
    • Content Management
    • Data Catalog
    • Data Flow
    • Data Integration
    • Data Labeling
    • Data Safe
    • Data Science
    • Database
    • Database Management
    • Database Migration
    • Database Tools
    • DevOps
    • Digital Assistant
    • Disaster Recovery
    • Globally Distributed Exadata Database on Exascale Infrastructure
    • DNS and Traffic Management
    • Document Understanding
    • Email Delivery
    • Events
    • File Storage
    • New File Storage with Lustre
    • Fleet Application Management
    • Functions
    • Fusion Data Intelligence
    • Generative AI
    • Generative AI Agents
    • GoldenGate
    • Health Checks
    • HeatWave
    • IAM with Identity Domains
    • IAM without Identity Domains
    • Integration 3
    • Integration Generation 2
    • Java Management
    • Kubernetes Engine
    • Language
    • Load Balancer
    • Logging
    • Logging Analytics
    • Managed Access
    • Managed Cloud Self Service Platform
    • New Managed Services for Mac
    • Management Agent
    • Management Dashboard
    • Media Services
    • Monitoring
    • Network Firewall
    • Network Load Balancer
    • Networking
    • NoSQL Database
    • Notifications
    • Object Storage
    • OCI Cache
    • OCI Control Center
    • OCI Database with PostgreSQL
    • OpenShift Container Platform on OCI
    • Ops Insights
      • About Oracle Cloud Infrastructure Ops Insights
      • Get Started with Ops Insights
      • Analyze Database Resources
      • Analyze Host Resources
      • Analyze Exadata Resources
      • Analyze SQL Insights
      • Analyze Database Performance
      • ADDM Spotlight in Ops Insights
      • Analyze Automatic Workload Repository (AWR) Performance Data
      • Exadata Warehouse
      • Dashboards
      • Data Object Explorers
      • News Reports
      • Actionable Insights
      • Collection Issues
      • Service Configurations
      • Ops Insights Metrics
      • Data Object Reference
      • Troubleshooting
    • Oracle APEX Application Development
    • Oracle Cloud Migrations
    • Oracle Linux
    • OS Management Hub
    • Process Automation
    • Pulse
    • Queue
    • Resource Manager
    • Resource Scheduler
    • Roving Edge Infrastructure
    • Search
    • Search with OpenSearch
    • Secure Desktops
    • Security Advisor
    • Security Zones
    • Service Catalog
    • Speech
    • Stack Monitoring
    • Streaming
    • Tagging
    • Threat Intelligence
    • Vault
    • Vision
    • Visual Builder
    • Visual Builder Studio
    • VMware Solution
    • Vulnerability Scanning
    • Web Application Acceleration
    • Web Application Firewall
    • WebLogic Management (Pre-GA)
    • Zero Trust Packet Routing
  • Developer Resources
  • Security
  • Marketplace
  • More Resources
  • Glossary
  • Oracle Cloud Console
Oracle Cloud
  • Getting Started with Oracle Cloud Infrastructure
  • Cloud Adoption Framework
  • Multicloud
  • Oracle Cloud Infrastructure Government Cloud
  • Applications Services
  • Infrastructure Services
  • Developer Resources
  • Security
  • Marketplace
  • More Resources
  • Oracle Cloud Console
  • Cloud Applications Documentation
  • Oracle.com Home
  • Oracle Help Center Home
Search

Oracle Cloud Infrastructure Documentation


Infrastructure Services
  • Getting Started
  • Oracle Cloud Infrastructure Cloud Adoption Framework
  • Oracle Cloud's Free Tier
  • Oracle Multicloud
  • Oracle Cloud Infrastructure Government Cloud
  • Oracle EU Sovereign Cloud
  • Applications Services
  • Infrastructure Services
    • Service Essentials
    • Access Governance
    • Analytics Cloud
    • Anomaly Detection
    • API Gateway
    • Application Dependency Management
    • Application Performance Monitoring
    • Archive Storage
    • Artifact Registry
    • Audit
    • Automated CEMLI Execution
    • Autonomous Linux
    • Bastion
    • Big Data Service
    • Billing and Cost Management
    • Block Volume
    • Blockchain Platform
    • Certificates
    • Cloud Advisor
    • Cloud Guard
    • Cluster Placement Groups
    • Compartment Quotas
    • Compliance Documents
    • Compute
    • Compute Cloud@Customer
    • Connector Hub
    • Console Dashboards
    • Container Instances
    • Container Registry
    • Content Management
    • Data Catalog
    • Data Flow
    • Data Integration
    • Data Labeling
    • Data Safe
    • Data Science
    • Database
    • Database Management
    • Database Migration
    • Database Tools
    • DevOps
    • Digital Assistant
    • Disaster Recovery
    • Globally Distributed Exadata Database on Exascale Infrastructure
    • DNS and Traffic Management
    • Document Understanding
    • Email Delivery
    • Events
    • File Storage
    • New File Storage with Lustre
    • Fleet Application Management
    • Functions
    • Fusion Data Intelligence
    • Generative AI
    • Generative AI Agents
    • GoldenGate
    • Health Checks
    • HeatWave
    • IAM with Identity Domains
    • IAM without Identity Domains
    • Integration 3
    • Integration Generation 2
    • Java Management
    • Kubernetes Engine
    • Language
    • Load Balancer
    • Logging
    • Logging Analytics
    • Managed Access
    • Managed Cloud Self Service Platform
    • New Managed Services for Mac
    • Management Agent
    • Management Dashboard
    • Media Services
    • Monitoring
    • Network Firewall
    • Network Load Balancer
    • Networking
    • NoSQL Database
    • Notifications
    • Object Storage
    • OCI Cache
    • OCI Control Center
    • OCI Database with PostgreSQL
    • OpenShift Container Platform on OCI
    • Ops Insights
      • About Oracle Cloud Infrastructure Ops Insights
      • Get Started with Ops Insights
      • Analyze Database Resources
      • Analyze Host Resources
      • Analyze Exadata Resources
      • Analyze SQL Insights
      • Analyze Database Performance
      • ADDM Spotlight in Ops Insights
      • Analyze Automatic Workload Repository (AWR) Performance Data
      • Exadata Warehouse
      • Dashboards
      • Data Object Explorers
      • News Reports
      • Actionable Insights
      • Collection Issues
      • Service Configurations
      • Ops Insights Metrics
      • Data Object Reference
      • Troubleshooting
    • Oracle APEX Application Development
    • Oracle Cloud Migrations
    • Oracle Linux
    • OS Management Hub
    • Process Automation
    • Pulse
    • Queue
    • Resource Manager
    • Resource Scheduler
    • Roving Edge Infrastructure
    • Search
    • Search with OpenSearch
    • Secure Desktops
    • Security Advisor
    • Security Zones
    • Service Catalog
    • Speech
    • Stack Monitoring
    • Streaming
    • Tagging
    • Threat Intelligence
    • Vault
    • Vision
    • Visual Builder
    • Visual Builder Studio
    • VMware Solution
    • Vulnerability Scanning
    • Web Application Acceleration
    • Web Application Firewall
    • WebLogic Management (Pre-GA)
    • Zero Trust Packet Routing
  • Developer Resources
  • Security
  • Marketplace
  • More Resources
  • Glossary
  • Oracle Cloud Console
Skip to main content

Ops Insights

Ops Insights provides comprehensive information about the resource use and capacity of databases and hosts. Use this service to analyze CPU and storage resources, forecast capacity issues, and proactively identify SQL performance issues across a database fleet.

What's new

Get Started

Concepts
Demo mode
Policy Reference
LiveLabs: Learn Ops Insights
Product page

Configure Agent-Managed Resources

Perform agent prerequisites
Create external handles
Enable databases
Enable hosts

Database Analytics

SQL Insights
Analyze SQL performance
Automatic Database Diagnostic Monitor (ADDM) Spotlight
Analyze Automatic Workload Repository (AWR) Hub data

Configure Cloud Resources

Enable Autonomous Database Full Feature
Perform prerequisites and enable Cloud resources

Configure Data Warehouses

Automatic Workload Repository (AWR) Hub
Exadata Warehouse

Visualize and Report

Get SQL performance statistics
Explore Data Objects
Create dashboards
Explore metrics
Create News reports

Community

Blog posts
Ops Insights Videos
Observability How-to Videos
Customer Advisory Board

Configure Enterprise Manager Managed Resources

Perform prerequisites
Enable databases, hosts, and Exadata systems

Capacity Planning

Databases
Hosts
Exadata systems

Developer Tools

REST APIs
SDKs and the CLI
CLI for Ops Insights

Support

Get help and contact Support
Create a service request
  • Copyright © 2024, Oracle and/or its affiliates.
  • About Oracle
  • Contact Us
  • Legal Notices
  • Terms of Use & Privacy
  • Document Conventions
  • Cookie Preferences