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
Plugin combo - Component related: Nothing was found.
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