Use and Manage Elastic Pools on Autonomous Database

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

Note:

Elastic pools are only available for Autonomous Database instances that use the ECPU compute model.

• About Elastic Pools
  Elastic pools help you improve operating efficiency and reduce costs by bringing all of your databases to the Cloud. This also supports consolidating resources and simplifying administration and operations by using Autonomous 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.
• 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.
• 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.