11 Shared Pool for Sharded Databases

This chapter describes UCP Shared Pool for sharded database in the following sections:

Sharding Data Source for Transparent Access to Sharded Databases

Oracle Database Release 21c introduces a new JDBC data source that enables Java connectivity to a sharded database without the need for an application to furnish a sharding key.

If you use the sharding data source, then you do not have to identify and build the sharding key and the super sharding key to establish a connection to the sharded database. This data source scales out to sharded databases transparently if you set the connection property oracle.jdbc.useShardingDriverConnection to true.