Oracle 8 shared connections
From: Reyes Ponce <reyes_at_naxs.com>
Date: Mon, 29 Mar 1999 13:47:14 -0500
Message-ID: <3UPL2.176$uS.14347_at_news20.ispnews.com>
I have Oracle 8.0.4 and have configured the server for Multi-Threaded Server Processes as specified in Chapter 4 of the Oracle 8 Administrator's guide. When I connect to the server using SQL*Plus or SQL Worksheet and then look at the connection by selecting from v$session, the SERVER column comes back as SHARED which is what I expected. If I connect via ODBC or OCI (using the OCI that came with 8.0.4) using the same connect string, the SERVER column shows up as NONE. If I use the original SID (turning on the multi-threaded stuff creates another SID for the multi-threaded connections) the connections for all applications show up as DEDICATED like they did before I turned on the multi-threaded stuff.
Date: Mon, 29 Mar 1999 13:47:14 -0500
Message-ID: <3UPL2.176$uS.14347_at_news20.ispnews.com>
I have Oracle 8.0.4 and have configured the server for Multi-Threaded Server Processes as specified in Chapter 4 of the Oracle 8 Administrator's guide. When I connect to the server using SQL*Plus or SQL Worksheet and then look at the connection by selecting from v$session, the SERVER column comes back as SHARED which is what I expected. If I connect via ODBC or OCI (using the OCI that came with 8.0.4) using the same connect string, the SERVER column shows up as NONE. If I use the original SID (turning on the multi-threaded stuff creates another SID for the multi-threaded connections) the connections for all applications show up as DEDICATED like they did before I turned on the multi-threaded stuff.
From the docs, it sounds like any connection to the new SID should create a SHARED connection, but it's not doing that for my OCI and ODBC connections. Does anyone have any ideas about why this is and what else I might have to do to get a shared connection throuh OCI and/or ODBC?
Thanks,
Rey Received on Mon Mar 29 1999 - 20:47:14 CEST