Create, Join or Manage an Elastic Pool

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

Create an Elastic Pool

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

Note

To create an elastic pool the instance must use the ECPU compute model.
  • 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 Database.

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

To create an elastic pool:

  1. On the Autonomous Database Details page click More actions and select Manage resource allocation.

    If Compute auto scaling switch is on:

    1. Switch off 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 click More actions and select Manage resource allocation to display the Manage resource allocation area.
  2. In the Manage resource allocation area expand Advanced options.
  3. Switch Enable elastic pool on.
  4. Select Create an elastic pool.
  5. 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 Updating. After the Lifecycle state changes to Available the changes apply immediately.

After you create an elastic pool, click More actions and select 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
Description of the illustration adb_elastic_pool_leader.png

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.

To create an elastic pool while provisioning or cloning:

  1. In the Database configuration area, switch off Compute auto scaling.
  2. In the Database configuration area, expand Advanced options.
  3. Switch on Enable elastic pool.
  4. Select Create an 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.

    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.

    For example:

    Description of adb_elastic_pool_create.png follows
    Description of the illustration adb_elastic_pool_create.png
  6. If applicable, enable the Bring your own license option.
  7. 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:

  • The instance must use the ECPU compute model.

    See Compute Models in Autonomous Database for more information.

  • Auto scaling must be disabled.

  • The instance must not be a member of an elastic pool.

To join an elastic pool:

  1. On the Autonomous Database Details page click More actions and select Manage resource allocation.

    If Compute auto scaling is on, switch this option off.

    1. Switch Compute auto scaling off.
    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 click More actions and select Manage resource allocation.
  2. In the Manage resource allocation area, expand Advanced options.
  3. Switch Enable elastic pool on.
  4. Select one of the following:
    • Join an existing elastic pool: Select this option when you want to join an elastic pool leader and the pool leader is in the same tenancy as the instance that is joining the elastic pool.

      In the Compartment field choose a compartment.

      In the Select pool leader field select the pool leader.

    • Join an existing elastic pool in a parent tenancy: Select this option when your tenancy is a child tenancy and you want to join an elastic pool leader in the parent tenancy.

      In the text field enter the OCID of the elastic pool leader.

      See Prerequisites for Elastic Pool Usage Across Parent/Child Tenancies for details on the required policies.

  5. Click Apply to add the instance to the elastic pool.

When you click Apply the Lifecycle state changes to Updating. After the Lifecycle state changes to Available the changes apply immediately.

After you create an elastic pool, click More actions and select 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.

To join an existing elastic pool while provisioning or cloning:

  1. In the Database configuration area, switch off Compute auto scaling.
  2. In the Database configuration area, expand Advanced options.
  3. Switch Enable elastic pool on.
  4. Select one of the following:
    • Join an existing elastic pool When you want to join an elastic pool leader in the same tenancy:

      In the Compartment field choose a compartment.

      In the Select pool leader field select a pool leader.

    • Join an existing elastic pool in a parent tenancy: When your tenancy is a child tenancy and you want to join an elastic pool leader in the parent tenancy.

      In the text field enter the OCID of the elastic pool leader in the parent tenancy.

      See Prerequisites for Elastic Pool Usage Across Parent/Child Tenancies for the required policies.

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 click More actions and 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 Updating. 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).