7 Starting, Stopping, and Scaling Autonomous Transaction Processing

This section describes starting and stopping Autonomous Transaction Processing and covers scaling processing power and storage capacity for the service.

Start Autonomous Transaction Processing

Describes the steps to start an Autonomous Transaction Processing instance.

  • Sign in to your Oracle Cloud Account at cloud.oracle.com.

  • From the Oracle Cloud Infrastructure left navigation list click Autonomous Transaction Processing.

  • On the Autonomous Databases page select an Autonomous Transaction Processing instance from the links under the Name column.

  1. On the Details page, from the Actions drop-down list, select Start.

    Start is only shown for a stopped instance.

  2. Click Start to confirm.

Note:

When an Autonomous Transaction Processing instance is started, Autonomous Transaction Processing CPU billing is initiated based on full-hour cycles of usage.

Stop Autonomous Transaction Processing

Describes the steps stop an Autonomous Transaction Processing instance.

  • Sign in to your Oracle Cloud Account at cloud.oracle.com.

  • From the Oracle Cloud Infrastructure left navigation list click Autonomous Transaction Processing.

  • On the Autonomous Databases page select an Autonomous Transaction Processing instance from the links under the Name column.

  1. On the Details page, from the Actions drop-down list, select Stop.
  2. Click Stop to confirm.

Note:

When an Autonomous Transaction Processing instance is stopped, the following details apply:

  • Tools are no longer able to connect to a stopped instance.

  • Autonomous Transaction Processing in-flight transactions and queries are stopped.

  • Autonomous Transaction Processing CPU billing is halted based on full-hour cycles of usage.

Terminate Autonomous Transaction Processing

Describes the steps to terminate an Autonomous Transaction Processing instance.

Note:

Terminating an Autonomous Transaction Processing database permanently deletes the instance and removes all automatic backups. You cannot recover a terminated database.
  1. Sign in to your Oracle Cloud Account at cloud.oracle.com.

  2. From the Oracle Cloud Infrastructure left navigation list click Autonomous Transaction Processing.

  3. On the Autonomous Databases page select an Autonomous Transaction Processing instance from the links under the Name column.

  1. On the Details page, from the Actions drop-down list, select Terminate.
  2. On the Terminate Database page enter the database name to confirm that you want to terminate the database.
  3. Click Terminate Database.

Add CPU or Storage Resources or Enable Auto Scaling

Describes how to scale your Autonomous Transaction Processing on demand by adding CPU cores or storage (TB). Also describes how to enable auto scaling.

  • Sign in to your Oracle Cloud Account at cloud.oracle.com.

  • Open the Oracle Cloud Infrastructure console by clicking the navigation icon next to Oracle Cloud.

  • From the Oracle Cloud Infrastructure left navigation list click Autonomous Transaction Processing.

  • On the Autonomous Databases page select an Autonomous Transaction Processing instance from the links under the Name column.

  1. From the Details page click Scale Up/Down.
  2. On the Scale Up/Down prompt, select the change in resources for your scale request.
    • Click up arrow to select a value for CPU Core Count. The default is no change.
    • Click up arrow to select a value for Storage (TB). The default is no change.
  3. To enable auto scaling, select Auto Scaling.

    Select auto scaling to allow the system to automatically use up to three times more CPU and IO resources to meet workload demand. See Use Auto Scaling for more information.

  4. Click Update to change your resources.

Remove CPU or Storage Resources or Disable Auto Scaling

Describes how to scale your Autonomous Transaction Processing on demand by removing CPU cores or storage (TB). Also describes how to disable auto scaling.

  • Sign in to your Oracle Cloud Account at cloud.oracle.com.

  • From the Oracle Cloud Infrastructure left navigation list click Autonomous Transaction Processing.

  • On the Autonomous Databases page select an Autonomous Transaction Processing instance from the links under the Name column.

  1. From the Details page click Scale Up/Down.
  2. On the Scale Up/Down page, select the change in resources for your scale request:
    • Click down arrow to select a value for CPU Core Count. The default is no change.
    • Click down arrow to select a value for Storage (TB). The default is no change.
  3. When auto scaling is enabled deselect Auto Scaling to disable auto scaling.
  4. Click Update to change your resources.

Note:

If auto scaling is disabled while more CPUs are in use than the specified CPU Core Count, then Autonomous Transaction Processing scales the number of CPU cores in use down to the CPU Core Count number.

Use Auto Scaling

You can select auto scaling during provisioning or later using the Scale Up/Down button on the Oracle Cloud Infrastructure console.

When you select auto scaling Autonomous Transaction Processing can use up to three times more CPU and IO resources than specified by the number of OCPUs currently shown in the Scale Up/Down dialog. When auto scaling is enabled, if your workload requires additional CPU and IO resources the database automatically uses the resources without any manual intervention required.

To see the average number of OCPUs used during an hour you can use the "Number of OCPUs allocated" graph on the Overview page on the Autonomous Transaction Processing service console. See Console Overview for more information on this graph.

Enabling auto scaling does not change the concurrency and parallelism settings for the predefined services. See Managing Priorities on Autonomous Transaction Processing for more information.

See Add CPU or Storage Resources or Enable Auto Scaling for the steps to enable auto scaling.