Using Your Autonomous Data Warehouse Database

The topics listed in this section provide detailed information and instructions on how to use your Autonomous Data Warehouse databases on shared Exadata infrastructure and dedicated Exadata infrastructure.

Note

For similar information about Autonomous Transaction Processing databases, see Using Your Autonomous Transaction Processing Database.

Topic Description Exadata Infrastructure
How to Create a Database Link Explains how to use database links to Oracle databases that are accessible from an Autonomous Data Warehouse database

Shared

Dedicated

Database Link Required Privileges Details the privileges required for a non-admin user to use database links

Shared

Manage Optimizer Statistics Describes Autonomous Data Warehouse commands for gathering optimizer statistics or enabling optimizer hints

Shared

Dedicated

Manage Automatic Workload Repository (AWR) Retention Includes information about controlling the retention time period for Autonomous Data Warehouse performance data

Shared

Predefined Database Service Names Resources and Connections Details the database service names for Autonomous Data Warehouse

Shared

Dedicated

Predefined Job Classes with Oracle Scheduler Explains how to control the priority of user requests in Autonomous Data Warehouse

Shared

Managing Concurrency and Priorities Idle Time Limits and MAX_IDLE_TIME Explains how to control session time limits in Autonomous Data Warehouse

Shared

Perform Manual Backups Explains how to manually back up Autonomous Data Warehouse databases to Object Storage

Shared

Dedicated