Some important enhancements to Oracle Sharding.
Now Supports CDB with a single PDB attached to it
- GSDCTL has new commands “add cdb”
- Supports CDB which has only one CDB
User Defined Sharding methods
- In previous releases the tablespaces are related to a tablespace set
- In user defined sharding , we can specify our own tablespaces
- Then add those tablespaces to shardspace
- Then add the shards, shard catalog
Consistency Levels for Multi Shard Queries –
- Initialization Parameter MULTISHARD_QUERY_DATA_CONSISTENCY
- Strong - SCN synchronization is performed across all shards
- Shard_local - SCN synchronization is not performed across all shards. Data is consistent within each shard
- Delayed_standby_allowed - SCN synchronization is not performed across all shards. Data is consistent within each shard. This setting allows data to be fetched from Data Guard standby databases when possible
Thanks
Suresh
Follow Me!!!