Overview

This document explains parameters related to sessions.

Method

1. ACTIVE_SESSION_HISTORY

   This parameter sets whether to collect statistics for sessions.

   Details of the ACTIVE_SESSION_HISTORY parameter are as follows.

   Category	Description
   Type	Boolean
   Default Value	N (Configurable values: Y, N)
   Attributes	Optional, Adjustable, Static, System
   How to Set	Set the TIP file and restart.

    

2. ACTIVE_SESSION_TIMEOUT

   This parameter sets the maximum time to wait for a client request while maintaining an active session state.

   If there is no client request for a continuous period equal to ACTIVE_SESSION_TIMEOUT (unit: seconds) after a session is established, the server disconnects the data-id="46"However, if the value is 0, it waits indefinitely.

   Details of the ACTIVE_SESSION_TIMEOUT parameter are as follows.

   Category	Description
   Type	Integer
   Default Value	0
   Attributes	Optional, Adjustable, Dynamic, Session
   How to Set	Set the TIP file and restart, or change with an ALTER statement.
   Syntax	- TIP file ACTIVE_SESSION_TIMEOUT = <time setting> - ALTER statement ALTER SESSION SET ACTIVE_SESSION_TIMEOUT = <time setting>

    

3. EXTRA_LISTENER_PORTS

   This parameter sets additional ports by specifying multiple ports.

   This parameter uses a semicolon (;) as both a delimiter and terminator. Therefore, it should be written in the form EXTRA_LISTENER_PORTS=9268;5787;.

   Details of the EXTRA_LISTENER_PORTS parameter are as follows.

   Category	Description
   Type	String
   Default Value	""
   Attributes	Optional, Adjustable, Static, System
   How to Set	Set the TIP file and restart.
   Syntax	- TIP file EXTRA_LISTlt;port setting>

    

4. LISTENER_IP

   This parameter sets the IP address to be used by the listener.

   If you set a specified IP address of the DB server as LISTENER_IP and a client attempts to connect, the connection request may be rejected if the destination address is not the IP address specified in LISTENER_IP.

   Category	Description
   Type	String
   Default Value	"-1"
   Attributes	Optional, Adjustable, Static, System
   How to Set	Set the TIP file and restart.
   Syntax	- TIP file LISTENER_IP = <IP setting>

    

5. LISTENER_PORT

   This parameter sets the port number to be used by the listener.

   Details of the LISTENER_PORT parameter are as follows.

   Category	Description
   Type	Integer
   Default Value	8629 (Configurable values: 1024~65535)
   Attributes	Optional, Adjustable, Static, System
   How to Set	Set the TIP file and restart.
   Syntax	- TIP file LISTENER_PORT = <PORT setting>

    

6. LISTENER_VIP_PORT

   This parameter sets the port to be used for VIP in the listener.

   Details of the LISTENER_VIP_PORT parameter are as follows.

   Category	Description
   Type	Integer
   Default Value	LISTENER_PORT (Configurable values: 1024~65535)
   Attributes	Optional, Adjustable, Static, System
   How to Set	Set the TIP file and restart.
   Syntax	- TIP file LISTENER_VIP_PORT = <PORT setting>

    

7. MAX_BG_SESSION_COUNT

   This parameter sets the number of sessions for internal tasks and task processing, excluding sessions requested by the LSNR, out of MAX_SESSION_COUNT.

   Details of the MAX_BG_SESSION_COUNT parameter are as follows.

   Category	Description
   Type	Integer
   Default Value	(MAX_SESSION_COUNT - MAX_FG_SESSION_COUNT) (Configurable values: 0~INT32_MAX)
   Attributes	Optional, Adjustable, Static, System
   How to Set	Set the TIP file and restart.
   Syntax	- TIP file MAX_BG_SESSION_COUNT = <number setting>

    

8. MAX_SESSION_COUNT

   This parameter sets the maximum number of sessions.

   If necessary, you can manually specify the number of worker processes and the number of worker threads per process using WTHR_PROC_CNT and WTHR_PER_PROC, respectively.
   The value should be equal to WTHR_PROC_CNT * WTHR_PER_PROC.

   If you do not manually specify WTHR_PROC_CNT and WTHR_PER_PROC, the default value for the number of worker threads per process (WTHR_PER_PROC) is 10,
   and the default value for the number of worker processes (WTHR_PROC_CNT) is MAX_SESSION_COUNT / WTHR_PER_PROC (rounded up if there is a remainder).

   For Windows NT, Windows Server 2003, and earlier versions, MAX_SESSION_COUNT should be set to an appropriate value of 1500 or less.

   Details of the MAX_SESSION_COUNT parameter are as follows.

   Category	Description
   Type	Integer
   Default Value	20 (Configurable values: 1~INT32_MAX)
   Attributes	Mandatory, Adjustable, Static, System
   How to Set	Set the TIP file and restart.
   Syntax	- TIP file MAX_SESSION_COUNT = <number setting>

    

9. USE_NET_KEEPALIVE

   This parameter sets whether to use the TCP Keepalive Socket Option (cleans up the session if the OS closes the socket due to no response from the client) in Tibero.

   Details of the USE_NET_KEEPALIVE parameter are as follows.

   Category	Description
   Type	Boolean
   Default Value	Y (Configurable values: Y, N)
   Attributes	Mandatory, Adjustable, Dynamic, System
   How to Set	Set the TIP file and restart, or change with an ALTER statement.
   Syntax	- TIP file USE_NET_KEEPALIVE = {Y|N} - ALTER statement ALTER SYSTEM SET USE_NET_KEEPALIVE = {Y|N}

   Tibero can only set whether to use the TCP KEEPALIVE function through the USE_NET_KEEPALIVE parameter. To change the KEEPALIVE time, the administrator must modify the kernel variables.

   Changing the KEEPALIVE time will apply to all other sockets as well, which may affect overall performance, so the time should be set in consultation with the system or network administrator.

   Below are the OS-specific methods for setting the TCP_KEEPALIVE parameter.

   OS	How to Set (for 1 minute)
   AIX	no -o tcp_keepidle=120
   Solaris	ndd -set /dev/tcp tcp_keepalive_interval 60000
   HP-UX	ndd -set /dev/tcp tcp_keepalive_interval 60000
   Linux	echo 60 > /proc/sys/net/ipv4/tcp_keepalive_intvl
   Windows	After running regedit, add KeepAliveTime to "\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters". Set the type to DWORD and the value to 60000.