Advanced Feature: Tuning Database Link

Attribute Name

Description

 

 

nsConcurrentOperationsLimit

Maximum number of outstanding operations

 

per LDAP connection. The default value is 2

 

operations per connection.

 

 

nsConcurrentBindLimit

Maximum number of outstanding bind

 

operations per TCP connection. The default

 

value is 10 outstanding bind operations.

 

 

nsBindRetryLimit

Number of times a database link attempts to

 

bind to the remote server. A value of zero (0)

 

indicates that the database link will try to bind

 

only once. The default value is 3 attempts.

 

 

nsConnectionLife

Connection lifetime, in seconds. Connections

 

between the database link and the remote

 

server can be kept open for an unspecified

 

time or closed after a specific period of time. It

 

is faster to keep the connections open, but it

 

uses more resources. For example, it may be

 

wise to limit the connection time for a slow

 

connection. A value of 0 indicates there is no

 

limit. By default, the value is set to 0. When

 

the value is 0 and there is a list of failover

 

servers in the nsFarmServerURL attribute, the

 

first server is never contacted after failover to

 

the alternate server. The default value is 0

 

seconds.

 

 

nsBindTimeout

Amount of time, in seconds, before the bind

 

attempt times out. The default value is 15

 

seconds.

 

 

nsAbandonedSearchCheckInterval

Number of seconds that pass before the

 

server checks for abandoned operations. The

 

default value is 1 seconds.

 

 

Table 3.5. Database Link Connection Management Attributes

For the list of database link configuration attributes, see Table 3.4, “Database Link Configuration Attributes”.

3.6.2. Detecting Errors During Normal Processing

Protect server performance by detecting errors during the normal chaining operation between the database link and the remote server. The database link has two attributes — nsMaxResponseDelay and nsMaxTestResponseDelay — which work together to determine if the remote server is no longer responding.

91

Page 111
Image 111
HP UX Red Hat Direry Server Software Detecting Errors During Normal Processing, Advanced Feature Tuning Database Link