Join or Leave an Elastic Pool

Autonomous Database instances that are added to an existing pool are pool members. As a pool member, you can join or leave an existing elastic pool.

Related Topics

Join an Elastic Pool

To join an elastic pool:
  1. Go to the Details page of the Autonomous Database.
  2. On the Autonomous Database Details page, select Manage resource allocation.
  3. On the Manage resource allocation dialog, verify if Compute auto scaling is disabled. If Compute auto scaling is enabled already, disable it by deselecting Compute auto scaling and clicking Apply.

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

  4. Once the Autonomous Database lifecycle state changes to Available, click Manage resource allocation again.
  5. Click Show advanced options.
  6. In the Elastic pool section:
    1. Select the Enable elastic pool check box.
    2. Select the Join an existing elastic pool option.
    3. Choose the pool leader from the Select pool leader in compartment select list.
  7. Click Apply.
The Lifecycle state changes to UPDATING. The changes apply immediately after the Lifecycle state changes to Available.

Join an Elastic Pool While Provisioning or Cloning an Autonomous Database

To join an elastic pool while provisioning or cloning an Autonomous Database:
  1. Launch the Create Autonomous Database or Clone Autonomous Database page following the steps documented in Create an Autonomous Database or Clone an Autonomous Database.
  2. In the Configure the database section:
    1. Select the Enable elastic pool checkbox.
    2. Select the Join an existing elastic pool option.
    3. Choose the pool leader from the Select pool leader in compartment select list.
  3. Continue with the remaining steps in creating or cloning the Autonomous Database.

Leave an Elastic Pool Autonomous Database

As a pool member, you can remove yourself from an elastic resource pool. See Notes for Leaving an Elastic Resource Pool in the Elastic Resource Pool Billing topic for the billing impact when a pool member leaves an elastic pool.

To leave an elastic pool:

  1. Go to the Details page of the Autonomous Database which you want to remove from the elastic pool.
  2. Locate Resource allocation, and click Leave pool in the Elastic pool field.
    The Leave pool confirmation dialog displays.
  3. Click Leave..
The Lifecycle state changes to UPDATING. The changes apply immediately after the Lifecycle state changes to Available.