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

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 the illustration adb_elastic_pool_leader.png

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

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

   See Choose Bring Your Own License Option While Provisioning or Cloning for more information.

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.

Shows the steps to join an existing 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.

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

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.

   
   

   
   Description of the illustration adb_elastic_pool_join.png

   
   

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

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.