Oracle Cloud Infrastructure Documentation

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 database in serverless and in dedicated deployments.

Note

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

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

Serverless

Dedicated

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

Serverless

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

Serverless

Dedicated

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

Serverless

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

Serverless

Dedicated

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

Serverless

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

Serverless

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

Serverless

Dedicated