1. Using Oracle Database Management for Autonomous Databases
  2. Set Up Oracle Database Management for Autonomous Databases
  3. Configure Oracle Database Management

Configure Oracle Database Management

As the assigned OMC Administrator, you must perform the tasks listed in the following table to configure Oracle Database Management to work with Autonomous Databases.

For information on the OMC Administrator role and the tasks a user assigned this role can perform, see About Oracle Database Management User Roles.

Task Description More Information
Access Oracle Management Cloud console Access Oracle Management Cloud console from the Instance Management page. See Access Oracle Management Cloud Console in Getting Started with Oracle Management Cloud.
Discover Autonomous Databases in Oracle Management Cloud Create a Cloud Discovery Profile for the Oracle Cloud Infrastructure tenancy or compartment that has the Autonomous Databases and discover them in Oracle Management Cloud. See Discover Autonomous Databases.
Access policies to assign Autonomous Database related privileges After you discover Autonomous Databases, you must go to the Access Policies page in Oracle Management Cloud and assign privileges to enforce user access.

Note: The tasks performed on the Access Policies page are only applicable when working with Autonomous Databases.

See Access Policies to Assign Autonomous Database Related Privileges.
Review Oracle Management Cloud license information Oracle Database Management for Autonomous Databases is bundled with the Autonomous Databases. After you discover the Oracle Cloud Infrastructure tenancy or compartment in Oracle Management Cloud, the Oracle Management Cloud – Standard Edition is automatically assigned to the Autonomous Database entities in the tenancy or compartment, and you can use all the available Oracle Database Management functionalities for Autonomous Databases at no additional cost.
Note: You can also enable:
  • The Oracle Management Cloud – Enterprise Edition and use Oracle IT Analytics for Autonomous Databases.

    You can use Oracle IT Analytics’ Database Performance Analytics, Database Resource Analytics, and SQL Analytics applications to:

    • Obtain insights and forecasts related to performance and resource utilization, based on long term data.
    • Identify degrading and inefficient workloads.
    • View the degrading SQLs, variant SQLs, inefficient SQLs, and SQLs with plan changes.
    • Detect the databases projected to reach capacity headroom limit.
    • Forecast future requirements of database CPU, I/O, and storage.

    For more information, see the following sections in Using Oracle IT Analytics.

  • The Oracle Management Cloud – Log Analytics Edition and monitor Autonomous Database logs. See Set Up Autonomous Database Log Collection in Using Oracle Log Analytics.
See Oracle Management Cloud License Information in Getting Started with Oracle Management Cloud.