Elastic Pool Operations

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

1. On the Autonomous AI 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 AI 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. It also displays the Total compute capacity and the Available compute capacity fields.

Description of the illustration adb_elastic_pool_leader.png

You can create or join an elastic pool when you provision or clone an Autonomous AI 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 AI Database Instance, Clone an Autonomous AI Database Instance, or Clone an Autonomous AI Database from a Backup.

Shows the steps to create a dedicated elastic pool using an existing Autonomous AI Database instance.

1. Click Oracle AI Database, and then click Autonomous AI Database.
2. On the Autonomous AI Databases page select an Autonomous AI Database from the links under the Display name column.
3. On the Autonomous AI Database details page, expand More actions and click Manage resource allocation.
4. Switch Compute auto scaling and Storage auto scaling off, if they are already on.
5. Click Apply.
   The lifecycle state changes to Scaling in Progress.
6. After the lifecycle state changes to Available, launch the Manage resource allocation dialog again by clicking Manage resource allocation under More actions from the Autonomous AI Database details page.
7. On the Manage resource allocation dialog, expand Advanced options.
8. Switch Enable elastic pool on, and select Create an elastic pool.
9. Switch Enable dedicated elastic pool on.
10. Choose a Pool ECPU count and Pool storage (TB) from the available options.
    At a minimum, you must select 256 ECPUs and 256 TB for compute and storage size.

    Note
    
    Creating a dedicated elastic pool is subject to resource availability and can take longer than creating a regular elastic pool without any impact on the database availability.
11. Choose a maintenance window by selecting a Day and Time (UTC) from the available options.
    Once you set maintenance window, this cannot be changed after the dedicated elastic pool is created.

    Note
    
    If a dedicated elastic pool already exists in a region, any additional dedicated elastic pools created in the same region cannot have custom maintenance windows. Instead, they will automatically inherit the maintenance window of the first dedicated elastic pool in that region.
12. Click Apply.
    The lifecycle state changes to Updating. After the lifecycle state changes to Available, the changes apply immediately.

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

1. Launch the Create Autonomous AI Database or Clone Autonomous AI Database page, depending on whether the database is being provisioned or cloned.
2. In the Database configuration section:
   1. Ensure to switch Compute auto scaling and Storage auto scaling off.
   2. Expand Advanced options.
   3. Switch Enable elastic pool on.
   4. Select Create an elastic pool.
   5. Switch Enable dedicated elastic pool on.
   6. Choose a Pool ECPU count and Pool storage (TB) from the available options.
      At a minimum, you must select 256 ECPUs and 256 TB for compute and storage size.

      Note
      
      Creating a dedicated elastic pool is subject to resource availability and can take longer than creating a regular elastic pool without any impact on the database availability.
   7. Choose a maintenance window by selecting a Day and Time (UTC) from the available options.
      Once you set maintenance window, this cannot be changed after the dedicated elastic pool is created.

      Note
      
      If a dedicated elastic pool already exists in a region, any additional dedicated elastic pools created in the same region cannot have custom maintenance windows. Instead, they will automatically inherit the maintenance window of the first dedicated elastic pool in that region.
3. Complete the remaining provisioning or cloning steps, as specified in Provision an Autonomous AI Database Instance, Autonomous AI Database, or Clone an Autonomous AI Database Instance, as appropriate.

Shows the steps to convert an elastic pool into a dedicated elastic pool.

1. Go to the Autonomous AI Database details page from the Oracle Cloud Infrastructure (OCI) console.
   Note
   
   You must go the details page of the Autonomous AI Database instance that is the pool leader of the elastic pool you want to convert into a dedicated elastic pool.
2. On Autonomous AI Database information, locate Resource allocation.
3. Click the Actions icon next to Elastic pool, and click Edit.
4. Once the Manage resource allocation dialog opens, expand Advanced options.
5. Switch Enable dedicated elastic pool on.
6. Choose a Pool ECPU count and Pool storage (TB) from the available options.
   At a minimum, you must select 256 ECPUs and 256 TB for compute and storage size.

   Note
   
   Converting into a dedicated elastic pool is subject to resource availability and can take longer than creating a regular elastic pool without any impact on the database availability.
7. Choose a maintenance window by selecting a Day and Time (UTC) from the available options.
   Once you set maintenance window, this cannot be changed after the dedicated elastic pool is created.

   Note
   
   If a dedicated elastic pool already exists in a region, any additional dedicated elastic pools created in the same region cannot have custom maintenance windows. Instead, they will automatically inherit the maintenance window of the first dedicated elastic pool in that region.
8. Click Apply.
   The lifecycle state changes to Updating. After the lifecycle state changes to Available, the changes apply immediately.

Shows the steps to join an existing elastic pool.

1. On the Autonomous AI 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 AI 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.

     You can view Available compute capacity field that displays the ECPU capacity available in the selected elastic pool.

     The individual ECPU allocation of the instance that is joining the elastic pool must be less than or equal to the available compute capacity.

   • 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 Elastic Pools Across Parent and Child Tenancies for details on the required policies.

   Tip:

   To join a dedicated elastic pool, you must enter the OCID of an Autonomous AI Database that is a pool leader of a dedicated elastic pool.
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 AI 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.

     You can view Available compute capacity field that displays the ECPU capacity available in the selected elastic pool.

     The individual ECPU allocation of the instance that is joining the elastic pool must be less than or equal to the available compute capacity.

   • 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 Elastic Pools Across Parent and Child Tenancies for the required policies.

   Tip:

   To join a dedicated elastic pool, you must enter the OCID of an Autonomous AI Database that is a pool leader of a dedicated elastic pool.
   
   

   
   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 AI Database Details page click More actions and select Manage resource allocation to display the Manage resource allocation panel.
2. Under Advanced options, in the Pool ECPU count field, select a value that is different than the current value.
   Note
   
   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.

   The console shows values for:

   • Total compute capacity (ECPU): Displays the total ECPU capacity of an elastic pool. It is defined as four times the configured pool size. For example, if the pool size is set to 128 ECPUs, the total ECPU capacity available in the pool is 512 ECPUs.
   • Available compute capacity (ECPU): Displays the ECPU capacity available in the selected elastic pool.
3. Click Apply.

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

Shows steps to modify the pool storage (TB) of a dedicated elastic pool.

1. On the Autonomous AI Database details page, click More actions and select Manage resource allocation to display the Manage resource allocation dialog.
2. Under Advanced options, in the Pool storage (TB) field, select a value that is different than the current value.
   The console shows values for:

   • Pool storage capacity: Displays the dedicated elastic pool's storage capacity. It is the same as the pool storage (TB) allocated while creating the dedicated elastic pool.
   • Available storage capacity: Displays the available storage (TB) in the dedicated elastic pool, that is, the difference between the pool’s total storage capacity and the storage currently used by all pool members.
3. Click Apply.

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

Shows steps to patch and resume a dedicated elastic pool patching.

1. On the Autonomous AI Database details page, locate Maintenance.
2. Check if Scheduled patching shows Active.
3. Click Pause next to Scheduled patching.
4. Select a value for Pause duration (week), and click Pause.
   The status of Scheduled patching under Maintenance on the Autonomous AI Database details page changes to Paused.
5. To resume patching, click Resume next to Scheduled patching.
6. Confirm by clicking Resume on the Resume maintenance dialog.
   Note
   
   Except for security patches, you can pause and resume maintenance for a dedicated elastic pool multiple times, but each dedicated elastic pool must receive a patch at least once every 30 days (4 weeks). Maintenance cannot be deferred beyond this period.
   The status of Scheduled patching under Maintenance on the Autonomous AI Database details page changes to Active.

Shows the steps for the pool leader to list elastic pool members.

1. On the elastic pool leader's Autonomous AI Database details page, select the Elastic pool members tab.
2. The Elastic pool members tab shows a list of elastic pool members.
   Note
   
   When you list pool members for an elastic pool in a parent tenancy, the listing includes all the pool members in the parent tenancy and the members in all child tenancies. See Elastic Pools Across Parent and Child Tenancies for more details.

As an elastic pool member you can remove yourself from an elastic pool. As an elastic pool leader you can remove pool members from an elastic pool.

1. On the Details page, under Resource allocation, in the Elastic pool field click Leave pool.

   This shows the Leave pool confirmation dialog.

2. In the Leave pool confirmation dialog, enter the database name.
3. Click Leave.

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

An elastic pool leader can remove pool members from an elastic pool.

1. On the Autonomous AI Database Details page, select the Elastic pool members tab.

   This shows the Elastic pool members tab, with a list showing details for each instance that is an elastic pool member.

2. Click at the end of a row for an instance you want to remove and in the drop down list select Remove from pool.

   This shows the Remove from pool confirmation dialog.

3. Click Leave to confirm.

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

Shows the steps to disable a dedicated elastic pool.

1. Go to the Autonomous AI Database details page from the Oracle Cloud Infrastructure (OCI) console.
   Note
   
   You must go the details page of the Autonomous AI Database instance that is the pool leader of the dedicated elastic pool you want to disable.
2. On Autonomous AI Database information, locate Resource allocation.
3. Click the Actions icon next to Elastic pool, and click Edit.
4. Once the Manage resource allocation dialog opens, expand Advanced options.
5. Switch Enable dedicated elastic pool off.
6. Click Apply.
   The lifecycle state changes to Updating. After the lifecycle state changes to Available, the changes apply immediately.

Shows the steps to terminate an elastic pool. Only the pool leader can terminate an elastic pool.

1. On the Autonomous AI Database Details page, click More actions and select Manage resource allocation.
2. In the Elastic pool area, select Terminate pool.
3. Click Apply to terminate the elastic pool.