Use and Manage Elastic Pools on Autonomous AI Database

Use an elastic pool to logically group your Autonomous AI Database instances, in terms of their allocation of compute resources, and to provide up to 87% cost savings.

• About Elastic Pools
  Elastic pools help you improve operating efficiency and reduce costs by bringing all of your databases to the Cloud. This allows you to logically group a large number of Autonomous AI Database instances, in terms of their allocation of compute resources, and simplify administration by using Autonomous AI Database.
• About Elastic Pool Billing
  Elastic pool usage is billed to the pool leader and billing is based on the elastic pool size and the actual hourly ECPU usage of the pool leader and the members. Elastic pool usage can exceed the pool size (pool capacity can be up to four times greater than the pool size).
• About Elastic Pool Billing with Autonomous Data Guard Enabled
  An Autonomous Data Guard primary database can use a local or a cross-region standby that is part of an elastic pool, either as a leader or a member.
• Prerequisites for Elastic Pool Usage Across Parent/Child Tenancies
  Provides information on required policies for working with elastic pools with a pool member in a child tenancy and the pool leader in the parent tenancy.
• Create, Join or Manage an Elastic Pool
  Shows the steps to create, join, or manage an elastic pool.
• List Elastic Pool Members
  Shows the steps for the pool leader to list elastic pool members.
• Use Efficient Statement Routing by Enabling ProxySQL on Autonomous AI Database
  ProxySQL enables unified access to multiple Autonomous AI Databases by routing statements for DML and queries, and eliminates the need to physically consolidate all the data into a single database.
• Offload Queries to Member Refreshable Clones
  When you have heavy read workloads, where a relatively small amount of data is scanned by multiple queries, you can offload queries (reads) either from an elastic pool leader or from an elastic pool member to Refreshable Clones.
• Use Unified Query Offload with Cloud Links
  When you have heavy read workloads using cloud links you can configure an elastic pool leader or member as a cloud links provider, where the provider enables ProxySQL query offload to offload queries (reads) to any number of refreshable clones.
• Remove Pool Members from an Elastic Pool
  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.
• Terminate an Elastic Pool
  Shows the steps to terminate an elastic pool. Only the pool leader can terminate an elastic pool.
• Elastic Pool Notes
  Provides information about elastic pool usage.