Manage an Elastic Pool as a Pool Leader
The Autonomous Database instance that creates an elastic pool is the pool leader. A pool leader can perform the following operations on an elastic pool.
- Change an Elastic Pool Shape
- List Elastic Pool Members
- Remove an Elastic Pool Member
- Terminate an Elastic Pool
Parent topic: Create and Manage Elastic Pools
Change an Elastic Pool Shape
Only a pool leader can change the elastic pool shape for an existing elastic pool.
To change the shape of an elastic pool (update the pool size):
Decreasing the CPU allocation, Pool ECPU count, to a value that cannot accommodate all the members of the elastic pool is not allowed.
For example, for an elastic pool with a Pool ECPU count of 256 ECPUs and a pool capacity of 1024 ECPUs: If the elastic pool contains eight (8) Autonomous Database instances with 80 ECPUs each for a total of 640 ECPUs, the elastic pool leader cannot decrease the Pool ECPU count to 128 ECPUs. In this case, if the pool size were reduced to 128 ECPUs, the pool capacity would be 512 ECPUs, which is less than the total allocation for the pool members (640 ECPUs).
Parent topic: Manage an Elastic Pool as a Pool Leader
List Elastic Pool Members
Parent topic: Manage an Elastic Pool as a Pool Leader
Remove an Elastic Pool Member
Parent topic: Manage an Elastic Pool as a Pool Leader
Terminate an Elastic Pool
Terminating an elastic pool is only allowed when there are no pool members in the elastic pool.
Parent topic: Manage an Elastic Pool as a Pool Leader