Re: Connect w/o Listener

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Sun, 01 Oct 2006 20:35:55 GMT
Message-ID: <4520247f.1593078@news.hetnet.nl>

On Fri, 29 Sep 2006 19:43:21 +0200, Frank van Bortel <frank.van.bortel_at_gmail.com> wrote:

>hberry schreef:
>> 10g
>>
>> How to connect to a local DB (localhost) without needing to start & go thru
>> the Listener ?
>>
>> thx
>>
>>
>Use a BEQUEATH connection:
>MY_ALIAS =
>(DESCRIPTION=
> (ADDRESS = (PROTOCOL = BEQ)(PROGRAM=oracle)
> (ARGV0=oracleORCL)
> (ARGS='(DESCRIPTION=(LOCAL=yes)(ADDRESS=(PROTOCOL=BEQ)))')
> )
> (CONNECT_DATA=(SID=ORCL)
> )
>)
>More on http://vanbortel.blogspot.com/2006/03/network-blues.html
>--
>Regards,
>Frank van Bortel
>
>Top-posting is one way to shut me up...

Hi Frank,

Can you also use this solution to connect a 9.2.0.6 database to a 8.1.4.7 database on the same server through a database link? And because these are two databases with two different oracle executables, do I have to specify things differently?

And if you can, could this affect the runtime considerably of the following statement:

INSERT /*+ APPEND */ INTO local_table
SELECT * FROM remote_table_at_dblink

I noticed that this statement uses a lot of CPU for processing the records that come over the database link with a TCP-protocol. I wonder if this is due to the nature of the TCP connection and if CPU consumption would be noticebly lower for a BEQ-protocol.

Kind regards, Jaap. Received on Sun Oct 01 2006 - 15:35:55 CDT