4 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.

  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.
  4. On the Details page, from the Actions drop-down list, select Start.

    Start is only shown for a stopped instance.

  5. 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 to stop an Autonomous Transaction Processing instance.

  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.
  4. On the Details page, from the Actions drop-down list, select Stop.
  5. 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.
  4. On the Details page, from the Actions drop-down list, select Terminate.
  5. On the Terminate Database page enter the database name to confirm that you want to terminate the database.
  6. Click Terminate Database.

Add CPU or Storage Resources

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

  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.
  4. From the Details page click Scale Up/Down.
  5. 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.
  6. Click Update to change your resources.

Remove CPU or Storage Resources

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

  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.
  4. From the Details page click Scale Up/Down.
  5. 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.
  6. Click Update to change your resources.