ChunkMigrationConnectionTimeout

In sharding, a connection request to a specific shard can occur while data is migrating from the original shard to a new one. This setting will pause the connection request until the migration completes or fails to migrate in the specified time, then connect to the correct shard with the data requested.

Declaration

// C#
public static int ChunkMigrationConnectionTimeout {get;set;}

Property Value

The minimum time, in seconds, for a pooled connection request to pause waiting for a chunk migration.

Remarks

Default is 120 seconds. This setting requires connection pooling to be enabled.

ODP.NET reads the chunk migration connection timeout setting only upon pool creation. A new timeout setting will not be used until a new pool is created.

If the connection requires only read-only access, then this setting will not be used. This setting is in effect for connections with chunk write access.

During chunk migration, an ODP.NET connection request obeys only the chunk migration connection timeout. All other connection timeout values, such as OracleConnection.ConnectionTimeout are ignored and not used.

Oracle recommends setting the ODP.NET chunk migration connection timeout value to a value greater than the chunk movement server timeout. One way to set this server timeout is using the Global Data Services Control Utility (GDSCTL) move chunk command's timeout option.

The OracleConnection ChunkMigrationConnectionTimeout property inherits from the OracleConfiguration ChunkMigrationConnectionTimeout property. The OracleConnection property can be separately set to override the property set in the OracleConfiguration class.