Optimize Costs with 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 allow you to logically group a large number of Autonomous AI Database instances, in terms of their allocation of compute resource and simplify their administration. Elastic pools help you improve operating efficiency and reduce costs by bringing all of your databases to the Cloud.
• About Dedicated Elastic Pools
  Autonomous AI Database lets you create elastic pools with all pool members and the pool leader located in the same infrastructure. These are called dedicated elastic pools.
• Elastic Pools Across Parent and Child Tenancies
  If your organization uses Oracle Cloud Infrastructure organization management (parent and child tenancy model), you can apply elastic pool cost savings by using an elastic pool that spans parent and child tenancies.
• Elastic Pool Operations
  When you create an elastic pool in Autonomous AI Database, your instance becomes the pool leader. Instances that you add to an existing pool become pool members. The operations you can perform depend on your role as a leader or member.
• Monitor Elastic Pool Usage and Cost Savings
  Using an elastic pool provides up to 87% compute cost savings. You can get a detailed breakdown of elastic pool usage and the cost savings using the tools, views, and reports supported by Autonomous AI Database.
• 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.