RE: Connection question?

From: Koivu, Lisa <lisa.koivu_at_efairfield.com>
Date: Wed, 28 Nov 2001 07:06:48 -0800
Message-ID: <F001.003CEE52.20011128060028@fatcity.com>

Hi Deepak

Here's what the doco says

The Bequeath protocol <glossary.htm> enables clients that exist on the same machine as the server to retrieve information from the database without using the listener. The Bequeath protocol internally spawns a dedicated server process for each client applications. In a sense, it does the same operation that a remote network listener does for your connection, yet locally.

Bequeath is used for local connections where an Oracle client application, such as SQL*Plus, communicates with an Oracle server running on the same machine

Tell me if I'm wrong but here's my take on it:  When I connect from my pc, there's a process on my PC and there's a corresponding process on the database, say on a Unix server.  Though the connection was initiated remotely, the process itself on the db server is still a local process that exists to communicate with the database. 

Am I wrong?  If so let me know.

-----Original Message-----

From:   Deepak Thapliyal [SMTP:deepakthapliyal_at_yahoo.com]
Sent:   Tuesday, November 27, 2001 5:25 PM
To:     Multiple recipients of list ORACLE-L

Subject:        RE: Connection question?

hey lisa

Thats what i was temted to reply as well {lol} .. but if you look closely .. both her conn are bequeth .. i was under the impression that bequeth was used only for local and not remote .. thats why we chose beq over tcp for db's that resided in same box for performance reasons .. or so i thought until now ;)

thoughts ..?

Thx
Deepak
--- "Koivu, Lisa" <lisa.koivu_at_efairfield.com> wrote:
> One is LOCAL=YES and one is LOCAL=NO
>
> One is Local, one isn't.
>
> Lisa Koivu
> Oracle Database Monkey
> Fairfield Resorts, Inc.
> 954-935-4117
>
>
> > -----Original Message-----
> > From:       Seema Singh [SMTP:oracledbam_at_hotmail.com]
> > Sent:       Tuesday, November 27, 2001 1:05 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:    Connection question?
> >
> > Hi
> > WHen I execute ps -ef |grep LOCAL on Solaris
> server the following output i
> >
> > see in
> >
> 1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> > 2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
> > What is the diffrence between 1 and 2.
> >
> > Thanks
> > Seema
> >
> >
>

---

> > Get your FREE download of MSN Explorer at
> http://explorer.msn.com/intl.asp
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Seema Singh
> >   INET: oracledbam_at_hotmail.com
> >
> > Fat City Network Services    -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California        -- Public Internet
> access / Mailing Lists
> >
>

---

> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from).  You may
> > also send the HELP command for other information
> (like subscribing).
>

---

Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: deepakthapliyal_at_yahoo.com


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Nov 28 2001 - 09:06:48 CST