Re: sqlplus login question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 10 Jul 2001 21:40:15 +0200
Message-ID: <tkmmd0i0k6m85c@beta-news.demon.nl>

"vk02720" <vk02720_at_my-deja.com> wrote in message news:4d814faa.0107101133.115a7566_at_posting.google.com...
> What is the difference in logging in using the following 2 ways on UNIX
(AIX)?
> sqlplus username/password_at_INST
> versus
> export ORACLE_SID=INST
> sqlplus username/password
>
>
> TIA
The first method will use whatever protocol you defined in your tnsnames.ora for inst (usually TCP/IP)
The second method will use the Bequeath protocol. This is a form of InterProcess Communication. As you are on the server, you shouldn't use a WAN protocol like TCP/IP to connect, as it has more overhead.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Tue Jul 10 2001 - 14:40:15 CDT