The profile configuration file SQLNET.ORA can be configured with the following advanced features:
TNS Time Out Value:
Net8 sends a probe periodically to verify that a client-server connection is still active. This is done to ensure that connections are not left open indefinitely due to abnormal client terminations. If the probe finds a dead connection, or a connection that is no longer in use, it returns an error. The connection is then terminated.
Note: Only available on the server.
Client Registration ID:
The listener includes a unique identifier in the log file. It will not make network transactions more secure, but will show up in both client and server log files. The identifier can be any string up to 128 characters long.
Turn off UNIX Signal Handling:
Configures the client to pass child process cleanup to the UNIX init process by disabling signal handlers.
Since the client application spawns a server process internally through the Bequeath protocol as a child process, the client application becomes responsible for cleaning up the child process when it completes. When the server process completes its connection responsibilities, it becomes a defunct process. Signal handlers are responsible for cleaning up these defunct processes.
Disable Out of Band Break:
Disables out of band breaks if the underlying transport that a client is using does not support it. Out of bound breaks allow the user to cancel an operation in progress. Disabling them means that all requests submitted must be completed.
To configure advanced profile information: