3 Monitoring and Administration Tasks
After you have discovered Autonomous Databases, you can perform the following monitoring and administration tasks using Oracle Enterprise Manager for Autonomous Databases.
As you review the information available in the following table, note that:
- For Autonomous Databases, Oracle Enterprise Manager provides a subset of the features that it provides for Oracle Databases. The "more information" links in the following table currently take you to generic information on Oracle Enterprise Manager support for Oracle Databases, and all the features may not be available for Autonomous Databases.
- When you click the options in the user interface that take you to other Performance, Security, Schema, and Administration pages, the Database Login page is displayed and you must enter the Database Admin User credentials. These credentials can also be configured as named credentials. For information on named credentials, see Credentials Management in Oracle Enterprise Manager Cloud Control Security Guide.
Task | Description |
---|---|
Monitor the state and workload of the Autonomous Database on the Database Home page |
To go to the Database Home page:
The Database Home page enables you to proactively monitor:
For information on:
|
Monitor performance and diagnose issues on the Performance Hub, SQL Monitoring, AWR, and Advisors pages |
Using Oracle Enterprise Manager, you can monitor the performance of an Autonomous Database and ensure that it performs optimally. From the Performance drop-down list on the Database Home page, you can select one of the following options:
For information on:
|
Keep the Autonomous Databases secure |
Oracle Enterprise Manager provides security features that control how a database is accessed and used. From the Security drop-down list on the Database Home page, you can select one of the following options:
|
Perform Schema Management tasks |
Oracle Enterprise Manager provides a comprehensive set of tools that allows you to manage all aspects of database objects such as tables, indexes, and views. From the Schema drop-down list on the Database Home page, you can select one of the following options to perform fundamental tasks such as creating, editing, and viewing schema objects:
|
Perform Database Administration tasks such as Storage Management and Automated Maintenance |
Oracle Enterprise Manager allows you to view and manage the storage structures of Autonomous Databases. From the Administration drop-down list on the Database Home page, you can select one of the following options:
For information on:
|