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 on shared Exadata infrastructure and dedicated Exadata infrastructure.

Note

For similar information about Autonomous Data Warehouse databases, see Using Your Autonomous Data Warehouse 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 Transaction Processing 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 Transaction Processing 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 Transaction Processing performance data Shared
Predefined Database Service Names Resources and Connections Details the database service names for Autonomous Transaction Processing

Shared

Dedicated

Predefined Job Classes with Oracle Scheduler Explains how to control the priority of user requests in Autonomous Transaction Processing Shared
Managing Concurrency and Priorities Idle Time Limits and MAX_IDLE_TIME Explains how to control session time limits in Autonomous Transaction Processing Shared
Perform Manual Backups Explains how to manually back up Autonomous Transaction Processing databases to Object Storage

Shared

Dedicated