Tuxedo Database Connections Test

If the Tuxedo Domain server is unable to connect to the database owing to the absence of adequate connections in the connection pool, then critical server operations may fail. Using this test, you can periodically monitor the usage of each connection pool and promptly detect when a pool runs short of connections. This way, the test provides useful pointers to resizing your connection pools.

Target of the test : A Tuxedo Domain Server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for every Group_name:Pool_name auto-discovered from the Tuxedo server being monitored.

Configurable parameters for the test
Parameter Description

Test period

How often should the test be executed.

Host

The host for which the test is to be configured.

Port

The port at which the specified host listens. The default port is 12345.

TuxDir

Specify the full path to the installation directory of the Tuxedo Domain server. For example, while monitoring a Tuxedo server on Windows, your TuxDir can be: E:\oraclehome\tuxedo11gR1

AppDir

Specify the full path to the application directory of the Tuxedo Domain server. For example, while monitoring a Tuxedo server on Windows, your appdir can be: E:\oraclehome\tuxedo11gR1\samples\atmi\simpapp

TuxConfig

Each BEA Tuxedo domain is controlled by a configuration file in which installation-dependent parameters are defined. The binary version of this configuration file is called TuxConfig. The TUXCONFIG file may be given any name; the actual name is the device or system filename specified in the TUXCONFIG environment variable. Specify the name of the TuxConfig file here. For example, while monitoring a Tuxedo server on Windows, your TuxConfig can be:E:\oraclehome\tuxedo11gR1\samples\atmi\simpapp\tuxconfig

Measurements made by the test
Measurement Description Measurement Unit Interpretation

Max connection pool size

 

Indicates the maximum number of connections in this pool.

Number

 

Current connection pool size

 

Indicates the current size of this pool.

Number

 

Used connections

 

Indicates the number of used connections relative to the size of this pool.

Number

Ideally, the value of this measure should be low.

Free connections

 

Indicates the percentage of unused connections in this pool.

 

Percent

A high value is desired for this measure. If the value is low, it indicates abnormal usage of the connection pool. You may want to consider resizing the pool, so that sufficient connections are always available in the pool.