Tuxedo To Database - Connections Management (Doc ID 2166765.1)

Last updated on JUNE 13, 2017

Applies to:

Oracle Tuxedo - Version 12.1.1 and later
Information in this document applies to any platform.

Goal

Tuxedo 12.1.1
Oracle database (also know as DB)

In production , we are struggling with high number of DB connections to an Oracle database and most of the connection (more than 10K ) are created by Tuxedo and we would like to know some information related to the two points below:

1. Is there any possibility to create DB connection pools? and Please suggest if there is any better solution to handle DB connections?

2. Tuxedo ubb configuration *SERVER section CLOPT parameter using the low/high "-p" option below to spawn instance.  Please recommend/suggest the best practice for production environments?
          productionMSSQ Y -p 1,120:2,1
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms