dat:obiee:obis:connection

Table of Contents

Parameter

There are 3 main parameters that control how many users can log in at one time:

Maximum connections in the connection pool. It controls the number of threads opened to a specific database from nqsserver.
OBIEE - DbGateway (DB_GATEWAY_THREAD_RANGE) from dbgateway. It controls the number of threads opened to all databases defined in the repository from nqsserver.
OBIEE - Server Thread. It controls the number of threads open for BI Server clients.

Articles Related

Example

Database	5
Connection pool per database	1
Maximum connections for each Connection Pool	100
Total connections across the .rpd	678
DB_GATEWAY_THREAD_RANGE	40-200

If all 678 Connection Pool connections are in use, only 200 will actually be active.
The other 478 will be queued up waiting. When a query finishes, one of the waiting jobs will become active.

Documentation / Reference

Stuck Threads For OBIEE 11g And Core Dump Files Generated