Easysoft ODBC-ODBC Bridge

Why does the OOB HTTP Server statistics page show active threads when there are no connections?

Last Reviewed:
28th October 2008

The OOB HTTP Server statistics page is a guide to what is happening and what has happened in the OOB ODBC server. The OOB Server registers a new active connection when a client successfully connects and a thread (or process) is started up to handle the ODBC connection. The server does not deregister the connection (as far as the statistics are concerned) immediately the client disconnects. The server looks for disconnected threads/process when there has been no incoming connection for a period of 5 seconds. This gives priority to incoming connections. This also affects the peak concurrent connection count e.g. if you write a program which connects and disconnects in one second but this is repeated every 3 seconds the active connections and peak concurrent connections will appear to increase until your program stops.

There is one situation in which is this not the case. If you set MaxClientConnect or MaxThreadCount to a value other than 0 to limit the connections, the server checks for terminating threads/processes every time a connection is made, so the active and concurrent counts will always be up to date immediately after an ODBC connection from a client.

This does not affect licensing in any way i.e. if you have a license limited to N concurrent connections the server does not use the active connections statistic to decide whether you can connect or not.

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)

Oracle is a registered trademark of Oracle Corporation and/or its affiliates.