Oracle Cloud Infrastructure Documentation

Using Your Autonomous Transaction Processing Database

The topics listed in this section provide detailed information and instructions on how to use your Autonomous Transaction Processing database in serverless and in dedicated deployments.

Note

For similar information about Autonomous Data Warehouse databases, see Using Your Autonomous Data Warehouse Database.

Topic Description Deployment Type
How to Create a Database Link Explains how to use database links to Oracle databases that are accessible from an Autonomous Transaction Processing 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 Transaction Processing 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 Transaction Processing performance data

Serverless

Predefined Database Service Names Resources and Connections Details the database service names for Autonomous Transaction Processing

Serverless

Dedicated

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

Serverless

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

Serverless

Perform Manual Backups Explains how to manually back up Autonomous Transaction Processing databases to Object Storage

Serverless

Dedicated