Different Ways of Connecting to Oracle

From: Matthias Koepf <mak_at_kis.datagroup.de>
Date: 1997/02/19
Message-ID: <330B0B1E.53DC@kis.datagroup.de>#1/1

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 Received on Wed Feb 19 1997 - 00:00:00 CST