Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Connect w/o Listener
Jaap W. van Dijk schreef:
> 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.
>
Oh - in addition to the (listenerless) BEQueath protocol, which may not alwyas be easy to set up, make it a habit of using IPC. It is far more efficient than TPC/IP for local traffic.
Use TCP/IP only for what is was meant: routable network traffic
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Mon Oct 02 2006 - 13:17:13 CDT