Scott Urman (surman_at_oracle.com) wrote:
[snip]
: These are Oracle shadow processes, started when a user process connects to
: the database. The DESCRIPTION means that these are connections using SQL*Net
: version 2, specificly the V2 bequeath adapter (the PROTOCOL part). This is
: the default adapter when you are connecting to a database on the same
: machine as your program. Try connecting with a connect string of 'p:' which
: will use the V1 pipe driver instead, and see what the process list says.
: --
Hmmm, I wonder if you could elaborate on the V1/V2 aspect. Are you
saying the unix pipe driver is using V1 sqlnet? Example, here's the
process that gets started when I use sqlplus on the same machine
that has the instance:
oracle 8828 8827 31 08:12:39 ? 0:00 oracleCMP P:4096,8,11,
Is this using V1? How can I make it use V2 ( and MTS )? Change the
entry in the PROTOCOL part of TNSNAMES.ORA, LISTENER.ORA ??
Thanks,