OBIEE - DbGateway (DB_GATEWAY_THREAD_RANGE)

Bi Server Architecture With Client

About

Dbgateway are the program that manage the database connectivity.

Parameters

DB_GATEWAY_THREAD_RANGE

DB_GATEWAY_THREAD_RANGE controls the number of Dbgateway threads opened to all databases defined in the repository from nqsserver.

It is set in nqsconfig.ini.

The lower number in the range is the number of threads that are kept open before Oracle BI Server takes action. If the number of open threads exceeds the low point in the range, Oracle BI Server terminates idle threads. For example, if DB_GATEWAY_THREAD_RANGE is set to 40-200 and 75 threads are open, Oracle BI Server terminates any idle threads.

Diagnostic

When an error message contains the term “Dbgateway”, it suggests that the database connectivity is the source of the error.





Discover More
Bi Server Architecture With Client
OBIEE - OBIS - Connection

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....
Bi Server Architecture With Client
OBIEE - Which Usage Tracking time measure should be used to gauge the performance of SQL retrieval time ?

TOTAL_TIME_SEC is the same as Response time in the query log. It is the response time for the execution of a logical request in the gateway. There are several times from the query log that are included...



Share this page:
Follow us:
Task Runner