From: jared@saturn.planet.net (Jared Hecker)
Subject: Re: Different Ways of Connecting to Oracle
Date: 1997/03/03
Message-ID: <5fem9t$ocl@jupiter.planet.net>#1/1
References: <330B0B1E.53DC@kis.datagroup.de>
Organization: Planet Access Networks - Stanhope, NJ
Newsgroups: comp.databases.oracle.server



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@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@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@kis.datagroup.de

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