Multi-threaded OCI application

From: rakesh <rakesh_at_mci2000.com>
Date: Thu, 28 May 1998 13:42:48 GMT
Message-ID: <sRdb1.147$zS5.253002_at_news.internetmci.com>

[Quoted] [Quoted] If one is writing a OCI application that has multiple threads, each thread accessing rows of multiple tables from a single database, which of the following is the best approach ? Note that there is only userid.

1. Have separate environment handles and separate user sessions for each sesssion.
2. Every thread shares the same user session. In this approach, does the application need to ensure that all SQL statements are serialized ?
3. Any other approach ?

thanks
rakesh Received on Thu May 28 1998 - 15:42:48 CEST