Re: oracle_sid environment variable

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 23 Dec 1999 18:59:21 +0100
Message-ID: <945972027.4890.0.pluto.d4ee154e@news.demon.nl>

Every database is managed by an instance of background processes. The instance needs to be identified. This identifier is called the SID. When you are on a (Unix) server, setting the $ORACLE_SID will make sure you use IPC-calls to communicate with the database, using semaphores, instead of using TCP/IP or any other network protocol. Consequently you don't need to use sqlplus username/password_at_database, you can leave out the @database part.

Hth,

--
Sybrand Bakker, Oracle DBA
<younkins_at_lucent.com> wrote in message news:38626014.BDA296D4_at_lucent.com...
> Could someone help me understand what the $ORACLE_SID is used for?
>
Received on Thu Dec 23 1999 - 11:59:21 CST