Re: Different Ways of Connecting to Oracle

Matthias -

You are using a two-task driver when you connect locally, which looks like a SQL*Net connection without the protocol stack in the middle.

That, in a nutshell, is the difference between the connectivity, by the way. When you are on the same machine as the instance you have the option of using a two-task connection or going through the protocol stack.

If you are running MTS, I _think_ two-task requires a dedicated process unless you have two MTS clauses in init.ora - one for IPC (two-task), one for TCP (or whatever your client protocol is). Examples abound in the SQL*Net V2 admin guide.

hth -

Regards,
jh

Matthias Koepf (mak_at_kis.datagroup.de) wrote:
: Hi,
: we are using Oracle 7.2.3 on HP-UX 10.
: Can anybody tell me, if there is difference in connecting to the Oracle
: Instance either direct or via SQL-Net V2, if the instance is running on
: the same machine?
: For example sqlplus:
 

: sqlplus user/pw results in an ORACLE-Process like
: kis 9436 9435 1 15:09:51 ? 0:00 oracleMAS
: (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
 

: and
 

: sqlplus user/pw_at_tns_string results in Oracle-Process like
: oracle 9360 1 1 15:09:19 ? 0:00 oracleMAS (LOCAL=NO)
 

: sqlplus and the instance which represents tns_string are running on the
: same machine.
 

: Which method of connecting is better or faster or doesn't it matter
: because they are on the same machine?
 

: Thanks for your answers
 

: Matthias Koepf
: =====================
: JenOptik Systemhaus
: E-Mail: mak_at_kis.datagroup.de

--
Jared Hecker - CODBA      |  ** HWA, Inc. **   Oracle and Sybase
jared_at_hwai.com            |    database architecture and administration
76276.740_at_compuserve.com  |    - serving the NYC/NJ region -