Oracle Cloud Infrastructure Documentation

Create, Join or Manage an Elastic Pool

Shows the steps to create, join, or manage an elastic pool.

Parent topic: Use and Manage Elastic Pools on Autonomous Database

Create an Elastic Pool

Shows the steps to create an elastic pool in an existing Autonomous Database instance.

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

  • From the Oracle Cloud Infrastructure left navigation menu click Oracle Database and then click Autonomous Transaction Processing.

  • On the Autonomous Databases page select an Autonomous Database from the links under the Display name column.

To create an elastic pool:

Note

To create an elastic pool the instance must use the ECPU compute model and the workload type must be Transaction Processing.
  1. On the Autonomous Database Details page select Manage resource allocation.

    Verify that Compute auto scaling is disabled.

    If Compute auto scaling is selected, disable Compute auto scaling:

    1. In the Manage resource allocation area, deselect Compute auto scaling.
    2. Click Apply.

      The Lifecycle state changes to Scaling in Progress. After some time the Lifecycle state changes to Available.

    3. On the Autonomous Database Details page select Manage resource allocation to display the Manage resource allocation area.
  2. In the Manage resource allocation area, click Show advanced options.
  3. Select Enable elastic pool.
  4. Select Create a elastic pool.
  5. Enter or choose a pool size in the Pool ECPU count field.

    Select a pool size from the list of pool shapes: 128, 256, 512, 1024, 2048, or 4096.

    By default each instance in an elastic pool is automatically assigned a maintenance window. By selecting a Pool ECPU count that is 1024 greater, you have the option of assigning a custom 2-hour maintenance window during which the leader and all elastic pool members are patched together. To select a custom maintenance window for your elastic pool, file a Service Request at Oracle Cloud Support.

    See About Scheduled Maintenance and Patching for more information.

  6. Click Apply to create the elastic pool.

When you click Apply, the Lifecycle state changes to Scaling in Progress. After the Lifecycle state changes to Available the changes apply immediately.

After you create an elastic pool, click Manage resource allocation to display the elastic pool information. In the Manage resource allocation area, the Elastic pool field shows Enabled, the Pool role field shows Leader, and the Pool ECPU count field shows the pool size you selected.

Description of adb_elastic_pool_leader.png follows

Create an Elastic Pool While Provisioning or Cloning an Instance

You can create or join an elastic pool when you provision or clone an Autonomous Database instance.

See Provision an Autonomous Database Instance for details on how to create an Autonomous Database for your workload type using the Create Autonomous Database dialog.

See Clone an Autonomous Database Instance or Clone an Autonomous Database from a Backup for details on cloning.

See Join an Elastic Pool While Provisioning or Cloning an Instance for details on joining an elastic pool while provisioning or cloning.

Note

To create an elastic pool the instance must use the ECPU compute model and the workload type you select must be Transaction Processing.

To create an elastic pool while provisioning or cloning:

  1. In the Configure the database area, click Show advanced options to show advanced options.
  2. Deselect Compute auto scaling.
  3. Select Enable elastic pool.
  4. Select Create a elastic pool.
  5. In the Pool ECPU count field, select a pool size from the list of pool shapes.

    The valid values that you can select are: 128, 256, 512, 1024, 2048, or 4096.

    Description of adb_elastic_pool_create.png follows

    By default each instance in an elastic pool is automatically assigned a maintenance window. By selecting a Pool ECPU count that is 1024 greater, you have the option of assigning a custom 2-hour maintenance window during which the leader and all elastic pool members are patched together. To select a custom maintenance window for your elastic pool, file a Service Request at Oracle Cloud Support.

    See About Scheduled Maintenance and Patching for more information.

  6. Complete the remaining provisioning or cloning steps, as specified in Provision an Autonomous Database Instance, Clone an Autonomous Database Instance, or Clone an Autonomous Database from a Backup.

Join an Existing Elastic Pool

Shows the steps to join an existing elastic pool.

To join an elastic pool, the following is required for the Autonomous Database instance:

To join an elastic pool:

  1. On the Autonomous Database Details page select Manage resource allocation.

    Verify that Compute auto scaling is disabled.

    If Compute auto scaling is selected, disable Compute auto scaling:

    1. In the Manage resource allocation area, deselect Compute auto scaling.
    2. Click Apply.

      The Lifecycle state changes to Scaling in Progress. After some time the Lifecycle state changes to Available.

    3. On the Autonomous Database Details page select Manage resource allocation to display the Manage resource allocation area.
  2. In the Manage resource allocation area, click Show advanced options to show the advanced options.
  3. Select Enable elastic pool.
  4. Select Join an existing elastic pool.
  5. In the Select pool leader in compartment field choose a pool leader in a compartment.
    1. Use the compartment shown or click Change Compartment to select a different compartment.
    2. Select a pool leader from the list of available pool leaders in the selected compartment.
  6. Click Apply to add the instance to the elastic pool.

When you click Apply the Lifecycle state changes to Scaling in Progress. After the Lifecycle state changes to Available the changes apply immediately.

After you create an elastic pool, click Manage resource allocation to see the elastic pool details. In the Manage resource allocations area, under Elastic pool, the Elastic pool field shows Enabled, the Pool role field shows Member, and the Elastic pool leader field shows a link to the pool leader.

Join an Elastic Pool While Provisioning or Cloning an Instance

You can create or join an elastic pool when you provision or clone an Autonomous Database instance.

See Provision an Autonomous Database Instance for details on how to create an Autonomous Database for your workload type using the Create Autonomous Database dialog.

See Clone an Autonomous Database Instance or Clone an Autonomous Database from a Backup for details on cloning.

See Create an Elastic Pool While Provisioning or Cloning an Instance for details on creating an elastic pool while provisioning or cloning.

Note

To join an elastic pool the instance must use the ECPU compute model and the workload type must be one of Transaction Processing, Data Warehouse, JSON Database, or APEX.

To join an existing elastic pool while provisioning or cloning:

  1. In the Configure the database area, click Show advanced options to show advanced options.
  2. Deselect Compute auto scaling.
  3. Select Enable elastic pool.
  4. Select Join an existing elastic pool.
  5. In the Select pool leader in compartment field choose a pool leader in a compartment.
    1. Use the compartment shown or click Change Compartment to select a different compartment.
    2. Select a pool leader from the list of available pool leaders in the selected compartment.
    Description of adb_elastic_pool_join.png follows

Complete the remaining provisioning or cloning steps, as specified in Provision an Autonomous Database Instance, Clone an Autonomous Database Instance, or Clone an Autonomous Database from a Backup.

Change the Elastic Pool Shape

Shows the steps for the pool leader to change the elastic pool shape for an existing elastic pool.

Note

Only a pool leader can modify the pool shape.

To change the shape of an elastic pool (update the pool size):

  1. On the Autonomous Database Details page select Manage resource allocation to display the Manage resource allocation area.
  2. In the Pool ECPU count field, select a value that is different than the current value

    By default each instance in an elastic pool is automatically assigned a maintenance window. By selecting a Pool ECPU count that is 1024 greater, you have the option of assigning a custom 2-hour maintenance window during which the leader and all elastic pool members are patched together. To select a custom maintenance window for your elastic pool, file a Service Request at Oracle Cloud Support.

    See About Scheduled Maintenance and Patching for more information.

  3. Click Apply.

    When you click Apply, the Lifecycle state changes to Scaling in Progress. After the Lifecycle state changes to Available the changes apply immediately.

Note

Decreasing the CPU allocation, Pool ECPU count, to a value that cannot accommodate all the members of the elastic pool is not allowed.

For example, for an elastic pool with a Pool ECPU count of 256 ECPUs and a pool capacity of 1024 ECPUs: If the elastic pool contains eight (8) Autonomous Database instances with 80 ECPUs each for a total of 640 ECPUs, the elastic pool leader cannot decrease the Pool ECPU count to 128 ECPUs. In this case, if the pool size were reduced to 128 ECPUs, the pool capacity would be 512 ECPUs, which is less than the total allocation for the pool members (640 ECPUs).