OCI

OCI Observability services provide a consistent way to monitor performance, strengthen governance, and streamline troubleshooting across the Oracle Database@AWS and their supporting components.

This topic explains the following primary components:
  1. OCI Monitoring helps track key metrics like availability, latency, CPU/memory where applicable, storage/I/O, and service health signals and drives proactive alerting for SLOs and incident response.
  2. OCI Logging centralizes collection and retention of operational logs (service logs and custom logs) so teams can correlate events across layers and reduce the time to isolate failures.
  3. OCI Log Analytics adds additional capabilities by indexing and analyzing large log volumes, applying patterns and insights for anomaly detection, root-cause analysis, and dashboards enabling faster diagnosis of database incidents and better operational visibility when Oracle Database runs in AWS but is managed with OCI-aligned controls and tooling.
  4. OCI Dashboard enables you to build performance monitoring, diagnosis, and data analysis solutions for Oracle Database@AWS resources.
  5. OCI Alarms enables you to automatically detect when a metric crosses a defined threshold and trigger an action.
  • OCI Monitoring

    You can use the Oracle Cloud Infrastructure Monitoring service to actively and passively monitor cloud resources using the Metrics and Alarms features. This section explains how the OCI Monitoring service works.

    This screenshot shows how the Monitoring service works.

    OCI Monitoring uses metrics to track resource behavior and alarms to notify you when metric values meet defined trigger conditions. Metrics are published as timestamped data points with associated dimensions and metadata, and can come from the Oracle Database@AWS service or custom metrics sent via the Monitoring API. Metric data is only available to you and to OCI features you enable. When you query metrics, the service returns aggregated results based on your selected time range, statistic, and interval; you can also filter by dimensions and specify resolution via the API. In the OCI Console, metrics are visualized as charts per metric for selected resources, and API responses include the metric name, namespace, and source compartment for use in external dashboards or visualization tools.

    OCI Monitoring has storage retention of 90 days for both metric definitions and alarm history entries. Queries and chart visualizations also have returned data limits, including a maximum of 100,000 data points per request, along with time-range maximums that depend on the selected resolution/interval.

    Viewing Metrics for Oracle Database@AWS

    Oracle Exadata Database Service on Dedicated Infrastructure

    Exadata VM Cluster Metrics
    1. From the OCI Console, open the navigation menu.
    2. Select Observability & Management and then select Service Metrics located under the Monitoring section.
    3. From the top navigation bar, select the region that contains the metric data you want to view.
    4. From the Service Metrics page, select the Compartment that contains your Exadata VM Cluster resources you want to monitor.
    5. From the Metric namespace dropdown list, select oci_database_cluster for the Exadata VM Cluster resource type.
    6. Select the Add link located next to Dimensions.
      1. From the Edit Dimensions page, select resourceName as Dimension name.
      2. From the Dimension value dropdown list, select the name of Exadata VM Cluster.
      3. Select the Save button to save your changes.
    7. You can also adjust both Start time and End time. This step is optional.
      1. Select the Calendar icon to choose your Start time and End time.
      2. From the Quick selects field, you can select the option based on your requirements.

    The Service Metrics page shows all default metric charts for the selected VM cluster resource in the selected region and compartment that publishes metrics to the selected metric namespace.

    This screenshot shows the Service Metrics.

    Observability Metrics for Exadata VM Cluster
    Metric Description Units
    ASMDiskgroupUtilization The percentage of usable space used in a Disk Group. Usable space is the space available for growth. The DATA disk group stores our Oracle database files. The RECO disk group contains database files for recovery, such as archives and flashback logs. Percentage
    CpuUtilization The percentage of CPU utilization. Percentage
    LoadAverage The system load average is measured over 5 minutes Integer
    MemoryUtilization This is the percentage of memory available for starting new applications without swapping. You can obtain the available memory using the following command: cat /proc/meminfo Percentage
    NodeStatus This indicates whether the host is reachable. Integer
    OcpusAllocated This is the number of OCPUs allocated. Integer
    SwapUtilization This indicated the percent utilization of total swap space. Percentage

    Exadata Container Database Metrics

    1. From the OCI Console, open the navigation menu.
    2. Select Observability & Management and then select Service Metrics located under the Monitoring section.
    3. From the top navigation bar, select the region that contains the metric data you want to view.
    4. From the Service Metrics page, select the Compartment that contains your Exadata Container Database resources you want to monitor.
    5. From the Metric namespace dropdown list, select oci_database for the Exadata Container Database resource type.
    6. Select the Add link located next to Dimensions.
      1. From the Edit Dimensions page, select resourceName_database as Dimension name.
      2. From the Dimension value dropdown list, select the name of Exadata Container Database.
      3. Select the Save button to save your changes.
    7. You can also adjust both Start time and End time. This step is optional.
      1. Select the Calendar icon to choose your Start time and End time.
      2. From the Quick selects field, you can select the option based on your requirements.
    This screenshot shows the Service Metrics.

    Observability Metrics for Exadata Container Databases

    Metrics Description Units
    BlockChanges The Average number of blocks changed per second. Changes per second
    CpuUtilization The CPU utilization expressed as a percentage, aggregated across all consumer groups. The utilization percentage is reported with respect to the number of CPUs the database is allowed to use, which is two times the number of OCPUs. Percentage
    CurrentLogons The number of successful logons during the selected interval. Count
    ExecuteCount The number of user and recursive calls that executed SQL statements during the selected interval. Count
    ParseCount The number of hard and soft parses during the selected interval. Count
    StorageAllocated Total amount of storage space allocated to the database at the collection time. GB
    StorageAllocatedByTablespace Total amount of storage space allocated to the tablespace at the collection time. In case of container database, this metric provides root container tablespaces. GB
    StorageUsed Total amount of storage space used by the database at the collection time. GB
    StorageUsedByTablespace Total amount of storage space used by tablespace at the collection time. In case of container database, this metric provides root container tablespaces. GB
    StorageUtilization The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces. Percentage
    StorageUtilizationByTablespace This indicates the percentage of storage space utilized by the tablespace at the collection time. In case of container database, this metric provides root container tablespaces.. Percentage
    TransactionCount The combined number of user commits and user rollbacks during the selected interval. Count
    UserCalls The combined number of logons, parses, and execute calls during the selected interval. Count

    Pluggable Database Metrics

    To gain additional OCI-based observability, you can enable the Database Management (Diagnostics & Management) in the OCI Console. For more information, see Enable Database Management for a Pluggable Database.

    Metrics Explorer

    You can use Metrics Explorer to create a query and retrieve data from Monitoring. These steps describe how to build a query in Metrics Explorer using Basic mode.
    Note

    For Advanced/MQL queries, use the MQL editor.
    1. From the OCI Console, open the navigation menu.
    2. Select Observability & Management and then select Metrics Explorer located under the Monitoring section. The page opens with an empty chart and query builder fields.
    3. From the top navigation bar, select the region that contains the metric data you want to query.
    4. Scroll down to Query section. From the Compartment dropdown list, choose the compartment that contains the metric.
    5. From the Metric namespace dropdown list, select the namespace where the metric is published. For example:
      • oci_database_cluster for VM Cluster.
      • oci_database for Container Database.
    6. From the Metric name dropdown list, select the a value that you want to create a chart.
    7. Based on you requirements, adjust the Interval and the Statistic fields.
    8. You can filter the results from the Metric dimensions section. This step is optional.
      1. From the Dimension name dropdown list, select a value. For example: resourceId.
      2. From the Dimension value dropdown list, select a value. For example: the OCID of the target resource.
      3. You can use the + Additional dimension button to add more name and value as filters. This step is optional.
      4. You can select the Aggregate metric streams checkbox to combine multiple metric streams into a single result. This step is optional.
    9. Once you review your information, select the Update Chart button to display the metric data.
    10. You can enable the Show Data Table toggle to view the same results in a table format instead of a chart. This step is optional.
    This screenshot shows how to monitor your query in Metrics Explorer.

    Autonomous AI Database Metrics

    1. From the OCI Console, open the navigation menu.
    2. Select Observability & Management and then select Service Metrics located under the Monitoring section.
    3. From the top navigation bar, select the region that contains the metric data you want to view.
    4. From the Service Metrics page, select the Compartment that contains the resources you want to monitor.
    5. From the Metric namespace dropdown list, select oci_autonomous_database for the Autonomous AI Database resource type.
    6. Select the Add link located next to Dimensions.
      1. From the Edit Dimensions page, select deploymentType as Dedicated and select resourceName as Dimension name.
      2. From the Dimension value dropdown list, select the name of Autonomous AI Database.
      3. Select the Save button to save your changes.
    7. You can also adjust both Start time and End time. This step is optional.
      1. Select the Calendar icon to choose your Start time and End time.
      2. From the Quick selects field, you can select the option based on your requirements.

    The Service Metrics page shows all default metric charts for all resources in the selected region and compartment that publishes metrics to the selected metric namespace.

    This screenshot shows how to monitor your metrics in Service Metrics.

    Observability Metrics for Autonomous AI Database

    Metrics Description Units
    BlockChanges The average number of blocks changed per second. (Statistic: Mean, Interval: 1 minute) changes per second
    CPUTimeSeconds The average rate of accumulation of CPU time by foreground sessions in the database instance over the time interval. The CPU time component of Average Active Sessions. (Statistic: Mean, Interval: 1 minute) Seconds per second
    CpuUtilization The CPU utilization expressed as a percentage, aggregated across all consumer groups. The utilization percentage is reported with respect to the number of CPUs the database is allowed to use, which is two times the number of OCPUs. (Statistic: Mean, Interval: 1 minute) Percent
    CurrentLogons The number of successful logons during the selected interval. (Statistics: Sum, Interval: 1 minute) Count
    DBTimeSeconds The average rate of accumulation of database time (CPU + Wait) by foreground sessions in the database instance over the time interval. Also known as Average Active Sessions. (Statistic: Mean, Interval: 1 minute) Seconds per second
    ExecuteCount The number of user and recursive calls that executed SQL statements during the selected interval. (Statistic: Sum, Interval: 1 minute) Count
    IOPS The average number of input-output operations per second. (Statistic: Mean, Interval: 1 minute) Operations per second
    IOThroughputMB The average throughput in MB per second. (Statistic: Mean, Interval: 1 minute) MB per second
    LogicalBlocksRead The average number of blocks read from SGA/Memory (buffer cache) per second. (Statistic: Mean, Interval: 1 minute) Reads per second
    OcpusAllocated The actual number of OCPUs allocated by the service during the selected interval of time. (Statistic: Count, Interval: 1 minute) Integer
    ParseCount The number of hard and soft parses during the selected interval. (Statistic: Sum, Interval: 1 minute) Count
    ParsesByType The number of hard or soft parses per second. (Statistic: Mean, Interval: 1 minute) Parses per second
    RedoSizeMB The average amount of redo generated, in MB per second. (Statistic: Mean, Interval: 1 minute) MB per second
    Sessions The number of sessions in the database. (Statistic: Mean, Interval: 1 minute) Count
    StorageAllocated The maximum amount of space allocated by tablespace during the interval. For container databases, this metric provides data for root container tablespaces. (Statistic: Max, Interval: 30 minutes) GB
    StorageAllocatedByTablespace The maximum amount of space allocated by tablespace during the interval. For container databases, this metric provides data for root container tablespaces. (Statistic: Max, Interval: 30 minutes) GB
    StorageUsed The maximum amount of space used during the interval. (Statistic: Max, Interval: 30 minutes) GB
    StorageUsedByTablespace The maximum amount of space used by tablespace during the interval. For container databases, this metric provides data for root container tablespaces. (Statistic: Max, Interval: 30 minutes) GB
    StorageUtilization The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces. (Statistic: Mean, Interval: 30 minutes) Percent
    StorageUtilizationByTablespace The percentage of the space utilized, by tablespace. For container databases, this metric provides data for root container tablespaces. (Statistic: Mean, Interval: 30 minutes) Percent
    TransactionCount The combined number of user commits and user rollbacks during the selected interval. (Statistic: Sum, Interval: 1 minute) Count
    TransactionsByStatus The number of committed or rolled back transactions per second. (Statistic: Mean, Interval: 1 minute) Transactions per second
    UserCalls The combined number of logons, parses, and execute calls during the selected interval. (Statistic: Sum, Interval: 1 minute) Count

    Pluggable Database Metrics

    To gain additional OCI-based observability, you can enable the Database Management (Diagnostics & Management) in the OCI Console. For more information, see Enable Database Management for a Pluggable Database.

    Metrics Explorer

    You can use the Metrics Explorer service to create a query and retrieve data from the OCI Monitoring service. These steps describe how to build a query in Metrics Explorer using the Basic mode.
    Note

    For Advanced/MQL queries, you can use the MQL editor.
    1. From the OCI Console, open the navigation menu.
    2. Select Observability & Management. Under Monitoring, select Metrics Explorer. The page opens with an empty chart and query builder fields.
    3. From the top navigation bar, select the region that contains the metric data you want to query.
    4. Scroll down to Query section. From the Compartment dropdown list, choose the compartment that contains the metric.
    5. From the Metric namespace dropdown list, select the namespace where the metric is published. For example:
      • oci_autonomous_database for Autonomous AI Database.
    6. From the Metric name dropdown list, select the a value that you want to create a chart.
    7. Based on you requirements, adjust the Interval and the Statistic fields.
    8. You can filter the results from the Metric dimensions section. This step is optional.
      1. Select Dedicated as deploymentType.
      2. From the Dimension name dropdown list, select a value. For example: resourceId.
      3. From the Dimension value dropdown list, select a value. For example: the OCID of the target resource.
      4. You can use the + Additional dimension button to add more name and value as filters. This step is optional.
      5. You can select the Aggregate metric streams checkbox to combine multiple metric streams into a single result. This step is optional.
    9. Once you review your information, select the Update Chart button to display the metric data.
    10. You can enable the Show Data Table toggle to view the same results in a table format instead of a chart. This step is optional.
    This screenshot shows how to query your metrics in Metrics Explorer.
  • OCI Logging

    Oracle Cloud Infrastructure (OCI) Logging is a fully managed, highly scalable service that centralizes log collection and access across your tenancy. It provides a single, consistent view of logs generated by OCI resources, capturing critical diagnostic and operational details about resource performance and access activity to support monitoring, troubleshooting, and security investigations.

    How OCI Logging Works for Oracle Database@AWS Resources

    You can use OCI Logging to enable, manage, and search logs related to your Oracle Database@AWS deployment and the supporting OCI-managed components. You can work with these log types:
    • Audit Logs: Events emitted by the OCI Audit service that record administrative and API activity (who did what, when, and where). Audit events can be viewed on the Logging > Audit page and are also searchable alongside other logs.
    • Service Logs: Logs generated by supported OCI services and integrations used with Oracle Database@AWS (for example, VCN Flow Logs for network visibility, and other OCI service logs where applicable). These services expose predefined log categories that you can enable or disable per resource to capture operational and access details.

    Audit Logs

    For Oracle Database@AWS, the OCI Audit service automatically captures calls to supported OCI public API endpoints as audit log events, providing a reliable record of administrative and operational activity in the OCI layer that supports your deployment.

    Audit logging applies across OCI services (with Object Storage logging focused on bucket-related events rather than individual object events) and includes actions initiated through the OCI Console, CLI, SDKs, custom clients, or other OCI services. Each audit event records details such as the time of the activity, the source that initiated it, the target resource, the action performed, and the response returned, along with identifiers, timestamps, and request/response parameters. You can access OCI Audit events through the OCI Console or via API/SDK, and use them for troubleshooting, usage tracking, compliance reporting, and security investigations.

    On the Audit page, you can explore audit logs. Audit logs are also searchable on the Search page, and you can view Audit logs in every compartment by selecting the /_Audit log group on the Search page.

    Audit logs are retained for 365 days. You can view the log retention period in the tenancy details page. For more information, see Viewing Tenancy Details. Retention period is a tenancy-level setting. The value of the retention period setting affects all regions and all compartments. The retention period cannot be changed.

    Viewing the Audit Logs

    1. From the OCI Console, open the navigation menu.
    2. Select Observability & Management. Under Logging, select Audit. The list of audit log events for the current compartment is displayed.
    3. Select the Compartment that you have a permission to view.
    4. Under User, add user filters. You can select multiple users.
    5. Under Resource, add one or more resource filters. You can select multiple resources.
    6. Under Request action types, choose one or more API operations to filter on the following:
      • GET
      • POST
      • PUT
      • PATCH
      • DELETE
    7. Under Event type, you can select one or more event type filters.
    8. Under Custom filters, start typing to see matching filter fields and operators, then select (or continue typing) the filter you want. This action functions the same as this field on the Logging Search page.
      Note

      If you want to find log events with a specific status code, put the code in quotes ("). For example: "404" to avoid partial matches.
    9. Under Filter by time, you can select a preset range.
      • Past 5 minutes (the default)
      • Past 15 minutes
      • Past hour
      • Past 3 hours
      • Today
      • Custom (choose your own using the Start Date and End Date fields)
      Note

      Custom time ranges are limited to 14 days.
    10. Select the Apply button to run the search and refresh results.
      Note

      The page refreshes as you adjust filters, but if time passes and new events arrive, select the Apply button again to reload results.
    Additional options:
    • Convert to search: This option opens the same results in Logging > Search and populates the query so that you can refine it and correlate it with other logs.
    • View query syntax: This option shows the query generated by your filters, including how multiple values are combined by using AND/OR logic.

    Exploring the Details of Events

    On the Explore events tab, audit log entries are listed with key fields such as Event time, User, Resource, ActionType, and Status. Select an entry to expand it and view the full event payload in a JSON view (similar to the Logging > Search experience), where you can expand and collapse nodes and use the copy icon to copy the JSON to your clipboard. To export results, select Export log data (JSON) to download the displayed audit log data as a JSON file.This screenshot shows how to explore events.

    Viewing the Activity Stream

    Use the Activity stream tab to view audit events in a chronological, visual list (newest to oldest). Select an event to expand and review the JSON details, and use the copy icon to copy the event content to the clipboard.This screenshot shows how to audit activity stream.

    Service Logs

    In Oracle Database@AWS, a service log is an OCI Logging resource used to collect and store log events for a specific context in your environment. For example, if you enable VCN Flow Logs for a subnet that supports database connectivity, OCI creates a dedicated log for that flow-log source. Each log has a unique OCID and is stored within a log group. A log group is a logical collection of logs created in a specific compartment, helping you organize logs by application, environment (development, test, and production) or operational function. Logs and log groups are searchable and can be used for analysis and operational actions. To get started, you enable logging on a resource associated with your Oracle Database@AWS deployment (for example, enabling a supported service log category such as VCN Flow Logs). OCI services expose predefined log categories that represent the types of events they can emit, and these categories are specific to each service (categories in one service don’t map to another).

    Enable Logging

    1. From the OCI Console, open the navigation menu.
    2. Select Observability & Management. Under Logging, select Logs.
    3. Select the compartment you have permission to work in.
    4. Under Actions, select the Enable service log option. The Enable resource log panel opens.
      1. The Resource compartment field populates with a value.
      2. From the Service dropdown list, select a service that you want to enable logging for.
      3. From the Resource dropdown list, select a resource that you want to enable logging for.
      4. From the Configure log section, choose the Log category and enter a descriptive name in the Log name field.
      5. If you want, you can enable the Enable auto archiving to object storage (legacy) toggle.
      6. From the Advanced options section, you can manage Log location, Log retention, and Tags.
      7. Review your information and then select the Enable button to enable resource log.
      This screenshot shows how to enable resource log.

    Details for Autonomous AI Database on Dedicated Exadata Infrastructure Logs

    Resources:
    • Autonomous Container Database
    • Autonomous AI Database

    Log Categories

    API Value (ID) Console (Display Name) Description
    ACD Database logs Database logs

    Contains content from log files:

    1. Attention logs:
      $ORACLE_BASE/diag/rdbms/<ORACLE_UNQNAME>/$ORACLE_SID/log/attention.log
    2. Alert logs:
       $ORACLE_BASE/diag/rdbms/<ORACLE_UNQNAME>/$ORACLE_SID/trace/alert_$ORACLE_SID.log
    ADB Migration logs Migration logs

    Contains content from log files:

    1. /u02/data/dbfs/<CDB_NAME>/<PDBGUID>/import*.log
    2. /u02/data/dbfs/<CDB_NAME>/<PDBGUID>/export*.log
    For more information, see Details for Autonomous AI Database on Dedicated Exadata Infrastructure.

    Details for VCN Flow Logs

    Resources:
    • Virtual Cloud Network (VCN)
    • Subnet
    • VNIC

    Log Categories

    API Value (ID) Console (Display Name) Description
    all Flow Logs (All records) Traffic is logged for existing and future VNICs in the subnet.
    vcn Flow Logs - vcn records Traffic is logged for existing and future VNICs in all subnets in the VCN.
    subnet Flow Logs - subnet records Traffic is logged for existing and future VNICs in the subnet. Similar to the all category, which is logged for existing and future VNICs in the subnet.
    vnic Flow Logs - vnic records Traffic is logged for specific VNICs in a VCN
    For more information, see Details for VCN Flow Logs.

    Check Logs

    1. From the OCI Console, open the navigation menu.
    2. Select Observability & Management. Under Logging, select Logs.
    3. Select the compartment that contains the log group that you want to check for logs.
    4. Select the Log you want to view.
    5. Select the Explore log tab to see the log entries.
    6. You can set the Time range field and add filters to narrow results.
    This screenshot shows how to check logs.
  • Oracle Log Analytics for Oracle Database@AWS provides a cloud-based capability in Oracle Cloud Infrastructure (OCI) to centralize and use log data across a multicloud deployment. It enables you to ingest and index logs from database-adjacent components and supporting infrastructure (in AWS, OCI), then enrich, aggregate, search, and correlate events to accelerate troubleshooting and root-cause analysis. With built-in tools to visualize and monitor log trends and anomalies, Oracle Log Analytics helps improve operational visibility, performance monitoring, and security investigations for Oracle Database@AWS.

    Oracle Log Analytics provides multiple ways to gain operational insights from logs in Oracle Database@AWS. You can:
    • Use the log explorer UI to search, filter, and investigate log events.
    • Aggregate and visualize log data using dashboards for ongoing monitoring and trend analysis.
    • Use the APIs to ingest log data and automate analysis workflows.
    • Integrate with other OCI services to correlate log insights with metrics, events, and notifications for end-to-end observability.

    Enable Log Analytics

    1. If this is your first time using Log Analytics in the selected region, the onboarding page is displayed. Select Start Using Log Analytics.
      1. The Enable Log Analytics dialog appears and creates the minimum required policies and a log group if they don’t already exist.
      2. From the navigation menu, select Observability & Management, and then select Log Analytics.
      3. Include Audit in subcompartments is enabled by default; clear it if you don’t want to collect audit logs from subcompartments.
      4. Select the Next button to continue.
      5. Select the Next button to configure OCI Audit Log collection.
    2. When the onboarding process is complete, select Take me to Log Explorer.
    3. You can now use Log Explorer to search and analyze collected logs for your Oracle Database@AWS.This screenshot shows how to navigate to Log Analytics.

    Create Log Groups to Store Your Logs

    You can create at least one Log Group to store the logs you collect in Oracle Log Analytics. Log groups live in a specific compartment, which is how you control user access to the logs within that group. Access is managed at the compartment level, users with access to a compartment can generally access all log groups in that compartment so place log groups in compartments that align with your segregation-of-duties requirements. If those requirements change, you can move a log group to a different compartment.

    1. From the OCI Console, open the navigation menu.
    2. Select Observability & Management and then select Log Analytics .
    3. From the left menu, select Administration and then select Log Groups.
    4. Select the Compartment where you want to create the log group.
    5. Select the Create Log Group button. Enter the following information:
      1. The Compartment field is read-only.
      2. Enter a descriptive name in the Name field to avoid confusion across compartments.
      3. Enter a description to help you identify it. For example: environment/app-based.
      4. Expand the Show Advanced Options section to use Tags. This step is optional.
      5. Select the Create button to create the log group.

    Setup OCI Service Connector Import Service Logs to the Log Group in Oracle Log Analytics

    1. From the OCI Console, open the navigation menu.
    2. Select Observability & Management, and then select Connectors that is located under Logging.
    3. Select the Create connector button to create a service connector to route logs from OCI Logging to Oracle Log Analytics.
    4. You can create the connector either from Logging or from Service Connector Hub.
      • From Logging: Navigate to Logging, Service Connectors and then select Create Connector.
      • From Service Connector Hub: Navigate to Service Connector Hub, and then select Create Service Connector.
    5. On the Create Service Connector page:
      1. Enter a Name and (optional) Description for the connector.
      2. Select the Compartment where the connector resource will be created.
      3. Under Configure Service Connector, set:
        1. Source to Logging
        2. Target to Logging Analytics (Oracle Log Analytics)
      4. Under Configure Source Connection, select the logs you want to ingest, for example Alert logs:
        1. Select the Compartment
        2. Select the Log group (Depending on your use-case select custom Log group created earlier or Audit log)
        3. Select the Log (the specific log you enabled/created earlier)
    6. To ingest additional logs with the same connector, select Another Log and repeat the log selection step. This step is optional.
    7. Under Configure Task, add filters to limit what gets sent to Log Analytics. This step is optional.
    8. Configure Target and select the Log group name that you created previously.
    9. Select the Create Connector to create the connector.
    10. After the connector is created, verify that the selected logs are available in Oracle Log Analytics . For example, in Log Explorer, verify that new events are being ingested.

    View Logs in Oracle Log Analytics for Oracle Database@AWS

    1. From the OCI Console, open the navigation menu.
    2. Select Observability & Management, and then select Log Explorer that is located under Log Analytics.
    3. Choose the Time range.
      • Last 15 minutes
      • Last 24 hours
      • Custom
    4. Use one of these ways to view data:
      • Search and Query: Enter the keywords or field-based filters and then run the search.
      • Source Selection: Filter by specific log sources and Add to search. For example, Audit, VCN Flow Logs, or custom ingested sources.
      • From the Visualizations field, select Records with Histogram.
    5. Select a result row to open the event details and expand fields to view the full context.
    Note

    If you don’t see any results, confirm:
    • Log Analytics is enabled in the region.
    • Logs are being ingested (sources/agents configured).
    • You are searching the correct compartment/log group and time range.
    This screenshot shows how to use Log Explorer.
  • Use LoganAI in Oracle Log Analytics.

    LoganAI is the artificial intelligence capability in Oracle Log Analytics that helps you analyze logs and log-derived data using AI. It can also pull OCI Monitoring metrics by using MQL and combine them with log data to support richer, context-aware analysis.

    LoganAI uses meta-llama or cohere model based on the selected region and availability of the model in that region. The exact regions in which LoganAI is currently available are listed in the menu when you enable LoganAI through the Configure LoganAI settings dialog box. For the regions in which Oracle Generative AI service is available, see regions.

    LoganAI supports Log Analytics users by providing:
    • AI-powered log summarization: Generates concise summaries and interpretations for individual logs, groups of logs, clusters, and charts, helping you understand large volumes of data quickly.
    • Actionable follow-up questions: Suggests relevant, context-aware next questions to guide deeper investigation and speed troubleshooting.
    • User-friendly explanations: Converts complex log entries and chart behavior into clear explanations that help connect technical signals to operational impact.
    • Seamless workflow integration: Makes AI features available directly in the Oracle Log Analytics UI, reducing tool switching and streamlining investigations.
    • Improved productivity: Automates time-consuming interpretation tasks so engineers and support teams can focus on remediation and higher-value work.

    Enable LoganAI

    1. From the OCI Console, open the navigation menu.
    2. Select Observability & Management, and then select Log Analytics.
    3. From the left menu, select Administration, and then select Service Details.
    4. Scroll down to the LoganAI field to view the status.
    5. To enable LoganAI, select the Configure LoganAI settings button.
    6. In the dialog, under Do you want to enable LoganAI for this tenancy?, choose the Yes option.
    7. Select the Generative AI Service region you want to use. LoganAI sends log data from your current region to the selected Generative AI region for processing.
    8. Under Default compartment for Generative AI Service, select the compartment used to access the Generative AI service. This must match the compartment referenced in the IAM policies for LoganAI, and users must have Generative AI access in this compartment.
    9. Accept the licenses: Review and accept any required model licenses, then select the I confirm that I have reviewed and accepted all required licenses for OCI Generative AI checkbox.
      Note

      Model and license requirements can vary by region.
    10. Under License acceptance requirements for users, choose how license acceptance is handled for other LoganAI users:
      • I will accept the license terms on behalf of all users, or
      • All users must accept the license the first time they use LoganAI, or
      • All users must accept the license once per session
    11. Under Validate Settings, select the Test button to confirm connectivity to the Generative AI Service. If the test fails, resolve the issue and retest. For more information, see Troubleshoot LoganAI Issues.
    12. Select the Update LoganAI settings to save and apply the configuration.
    TTTTTTThis screenshot show how to enable LoganAI.

    The Explain feature in LoganAI uses artificial intelligence to summarize and interpret log messages and certain charts in Log Explorer. To use it, select the AI icon wherever it appears in Log Explorer visualizations that display or tabulate log records.

    LoganAI Explain is available in these modes:

    • Single Log Explain: Select the AI icon on an individual log record to get an explanation of that record and ask follow-up questions.
    • Multi-log Explain: Select the AI icon above the log records list to generate an explanation across the current set of log messages.
    • Cluster Explain: In the Cluster visualization, select the AI icon on a cluster tab to analyze and summarize cluster patterns.
    • Chart Explain: For AI-enabled charts, select the AI icon below the chart to get an explanation of what the chart indicates.
    This screenshot show how to enable LoganAI.
  • OCI Dashboard

    Management Dashboard lets you build performance monitoring, diagnosis, and data analysis solutions for Oracle Database@AWS resources, using powerful visualization options to gather real-time and historical data and display it in widgets. It provides Oracle-defined dashboards, widgets, and filters for common monitoring scenarios, as well as the ability to create custom dashboards and widgets to meet specific needs.

    Create a Dashboard

    1. From the OCI Console, open the navigation menu.
    2. Navigate to Dashboards located under Home.
    3. Select the New dashboard button.
    4. Choose how to create it:
      • Start from a template: This option enables you choose from a collection of dashboards and templates are populated with preconfigured widgets that you can modify as needed.
      • Build from scratch: This option enables you start with an empty dashboard which you must choose which widgets to add and configure.
    5. In the Create new dashboard panel, enter the following information:
      1. Enter a name in the Dashboard name field. The name can be up to 100 characters. It must not include the following characters: <>()=/'"&\
      2. The Description is optional field.
      3. Select the Compartment where the dashboard resides in.
      4. Select an existing group or create a new one for Dashboard group.
      5. Select Show additional options to add tags. This step is optional.
      6. Select the Create button.
    6. Once the creation of a blank dashboard is complete, select the + Add widget button.
    7. In the Add new widget window , choose the Monitoring widget.
    8. In the dashboard widget, select Configure to open the Configure Monitoring widget dialog.
      1. Under Set visualization parameters, configure the following:
        1. Enter a Name for the widget.
        2. Enter a Description. This step is optional.
        3. Chart type: Select Line Chart.
        4. Interval: Select the interval for how often the chart refreshes.
        5. Filter by time: Select the time window shown in the chart.
      2. Under Configure metric query, specify the following:
        1. Select the Region.
        2. Select Change Compartment to use a different compartment. This step is optional.
        3. Select the Namespace. You can select the service or application creating the metric.
        4. Select the Metric Name . Select one metric per widget as options depend on compartment or namespace.
        5. Select the Statistic. It is an aggregation function for the metric data.
      3. In Metric Settings, you can filter using dimensions. This step is optional.
        1. Dimension Name. For example, resourceName.
        2. Dimension Value. For example, the OCID or resource identifier
        3. Use + Additional Dimension to add filters. You can use Remove (x) to delete one.
      4. Select the Configure button to save your changes.
    9. Repeat step 7 and 8 to add more widgets. You can add as many as metrics you want.
    10. Click on Save.This screenshot shows the dashboard.
  • Managing Alarms in OCI Monitoring

    OCI alarms let you automatically detect when a metric crosses a defined threshold and trigger an action (for example, send a notification, run an automation, or open an incident workflow). Effective alarm management includes creating alarms for critical metrics, keeping alarm rules up to date as systems change, suppressing alarms during planned maintenance to reduce noise, and deleting alarms that are no longer relevant.

    Create a threshold alarm in OCI Monitoring to send a notification when a metric crosses a specified threshold. For example, the following alarm triggers when average CPU utilization over a 1‑minute interval exceeds 80%: CpuUtilization[1m].mean() > 80

    On the Create Alarm page, the metric chart displays a dashed red line representing the threshold (80%). When a data point exceeds that line, the alarm transitions to a firing state and sends the configured notification.

    1. From the OCI Console, open the navigation menu.
    2. Select Observability & Management, and then select Alarm Definitions located under the Monitoring.
    3. Choose the Compartment.
    4. Select the Create Alarm button. The Create Alarm page opens in Basic Mode.
    5. Enter an Alarm name.
    6. Enter an Alarm summary. This step is optional. You can use dynamic variables.

      For example: {{severity}} alarm triggered because threshold got breached due to {{metricValues}} at {{timestamp}}.

    7. In Metric description, define which metric the alarm evaluates:
      1. Compartment: Where the target resources and the alarm will be stored.
      2. Metric namespace: Service/application emitting the metric. For example, oci_autonomous_database.
      3. Resource group: Custom metrics only (not used for service metrics).
      4. Metric name: The metric to evaluate.
      5. Interval: It is an aggregation window that you can specify a custom interval if needed.
      6. Statistic: Aggregation function (for example, Mean, Rate, Sum, Max, Min, Count, P50, P90, P95, P99)
    8. (Optional) In Metric dimensions, filter the metric data evaluated by the alarm:
      • Dimension name: For example, resourcename.
      • Dimension value: Select the dimension value.
      • Additional dimension: Add more filters as needed.
      • Aggregate metric streams: Combine multiple streams into one value.
    9. In Trigger rule, define when the alarm fires:
      1. Operator: For example, >, <, between, outside
      2. Value: Enter threshold value(s).
      3. Trigger delay minutes: How long the condition must persist before firing
      4. Alarm severity: For example: Critical, Error, Warning, Info.
      5. Alarm body: Human-readable message (include runbook guidance/links if helpful).
      6. Additional trigger rule: Add more conditions if needed. This step is optional.
        Note

        The chart in this section updates dynamically to show recent metric data based on your selections.
    10. Under Define alarm notifications (Destination), select where to send notifications:
      1. Destination service:
        1. Notifications: Send to an ONS topic (each subscription receives the message)
        2. Streaming: Send alarm messages to a stream (recommended for higher message rates)
      2. Compartment: Where the destination topic/stream exists
      3. Topic (for Notifications) or Stream (for Streaming)
      4. (Optional, Notifications only) Notification subject: Custom title (supports dynamic variables)
      5. (Optional) Create a topic: Create a new topic and subscription (for example, Email, HTTPS, PagerDuty, Slack, SMS, etc.)
      This screenshot shows how to create alarms.
    11. For Message grouping, choose one:
      • Group notifications across metric streams, or
      • Split notifications per metric stream
    12. For Message format (Notifications only), choose one:
      • Send formatted messages
      • Send Pretty JSON messages
      • Send raw messages
    13. (Optional) Enable Repeat notification to resend alerts at a set interval while the alarm is firing.
    14. (Optional) Enable Suppress notifications to mute evaluations/notifications during a maintenance window (set start time, end time, and an optional description).
    15. (Optional) Clear Enable this alarm? to create the alarm without starting evaluation immediately.
    16. (Optional) Add tags under Show advanced options (free-form tags require create permission; defined tags require tag-namespace permissions).
    17. Select Create alarm.

      The new alarm appears on the Alarm Definitions page. If enabled, Monitoring begins evaluating the metric and sends notifications when the trigger conditions are met.

      This screenshot shows how to create alarms.

    For more information, see Best Practices for Your Alarms.