Typical Workflow for Using Autonomous Transaction Processing

Describes the steps to start using Autonomous Transaction Processing.

Task Description More Information

Create and log in to your cloud account

Provide your information and sign up for an Oracle Cloud Service.

Getting Started with Oracle Cloud

Provision Autonomous Transaction Processing

Create an Autonomous Transaction Processing instance.

Provision Autonomous Transaction Processing

Quickstart Tutorial: Getting Started and Provisioning an Autonomous Database

Start the database

Start and verify that an Autonomous Transaction Processing instance is up and running.

Start Autonomous Transaction Processing

Create database users and obtain security credentials

Create accounts for your users and assign them appropriate privileges. Assign the necessary Autonomous Transaction Processing roles.

Create Users with Autonomous Transaction Processing

Connect to your database using SQL Developer

Download SQL Developer or another database client tool. Obtain security credentials and connect to your Autonomous Transaction Processing.

Connect to Autonomous Transaction Processing Using Oracle Database Tools

Connect to your database using a database client

Download a database client. Obtain security credentials and connect to your Autonomous Transaction Processing instance.

Connecting to Autonomous Transaction Processing

Scale the database

Use the Oracle Cloud Infrastructure Console to scale an instance to add or remove CPU or storage resources.

Starting, Stopping, and Scaling Autonomous Transaction Processing

Load data into the database

Use the available tools to load data into the database.

Loading Data with Autonomous Transaction Processing

Monitor the database

Check on the health and performance of the database.

Managing and Monitoring Performance of Autonomous Transaction Processing

Manage the database

Check on the day-to-day operation of your service, monitor performance, and review important notifications.

All aspects of the database lifecycle are simplified by the service, including patching and upgrading the database. You can obtain service information including the service and database version from the service console.

Backing Up and Restoring Autonomous Transaction Processing

Clone the database

Use the Oracle Cloud Infrastructure console to clone a database. You can choose to clone either the full database or only the database metadata.

Cloning or Moving a Database with Autonomous Transaction Processing