OCI server and user sessions

Is it possible to run multiple user sessions on one server connection. i.e., call OCIServerAttach() once and then call OCISessionBegin() for multiple, concurrent users on the same server.

If this is possible does this buy you anything? I assume such a setup would cause
contention on the server handle.

Currently I have a multi-threaded app, each thread opens up a server connection at startup and then a user session is layered on this (OCISessionBegin()), work is done then the session is ended (OCISessionEnd()). Then the next request again uses the server connection associated with the thread at startup, but a new user session is started. This seems to work very well, but I was wondering if there are improvements over this server/session mgmt sequence (e.g., Run one server for all sessions)

Thanks,

        Bill Received on Thu Feb 11 1999 - 02:42:25 CET