Database Link Limits and Controls
Use the Limits and Controls tab to override the defaults set in Default Creation Parameters tab of the Database link Settings node. You can customize how the database link returns data to client applications and manages connection, and you can configure cascading chaining (in which one database link connects to another).
Control Client Return. These options help you specify how the database link responds to client application requests.
-
Return referral on scoped search. Select this option to return referrals to client applications in response to scoped searches. Choosing to return referrals optimizes directory server performance, as referrals are more efficient than searching for data in remote databases.
-
Size limit X entries. Specifies the number of entries the database link returns in response to a search request. The default size limit is 2000 entries. The range is from -1 (no limit) to 2147483647.
-
Time limit X seconds. Specifies the search time limit for the database link. After the time limit has passed, the connection is timed out. The default value is 3600 seconds. The value range is -1 (for no limit) to 2147483647.
Cascading Chaining. Use the following options to configure cascading chaining, when one database link points to another database link.
-
Check local ACI. Select this checkbox to enable evaluation of local ACIs on all database links involved in a chaining operation.
-
Maximum hops. Specifies the number of hops, or times a database link contacts another, allowed. When one database link connects to another, this count decrements. Each subsequent database link contacted further decrements the count. If a server receives a count of 0 it determines that a loop has been detected and notifies the client application.
-
The default maximum hops value is 10. The range of values is 0 to 20.
Connection Management. Use these options to configure the pool of connections maintained by the database link with the remote server.
-
Maximum TCP connection(s). Maximum number of TCP connections the database link establishes with the remote server. The default value is 3 connections. The value range is 0 to 50.
-
Bind timeout. Amount of time, in seconds, before the bind attempt times out. The default value is 15 seconds.
-
Maximum binds per connection. Maximum number of outstanding bind operations per TCP connection. The default value is 10 outstanding bind operations. The range of values is from 1 to 25.
-
Timeout before abandon. The number of seconds that pass before the server checks for abandon operations. The default value is 10 seconds. The range is 0 to 2147483647.
-
Maximum LDAP connection(s). Maximum number of LDAP connections the database link establishes with the remote server. The default value is 10 connections. The value range is 1 to 50.
-
Maximum bind retries. Number of times a database link attempts to bind with the remote database. A value of zero indicates that the database link will try to bind only once. The default value is 3 attempts. The range is from 0 to 10.
-
Maximum operations per connection. Maximum number of outstanding operations per connection. The default value is 10 operations per second. The range is from 0 to 50.
-
Connection life (sec). You can keep connections between the database link and the remote database open for an unspecified time, or you can close them after a specific period. It is faster to keep the connections open, but it uses more resources. The range is from 0 (no limit) to 2147483647 seconds.