Re: Use Bequeth or IPC protocol to speed up large table copy between instances on the same server?

David,

Are you using the TWO_TASK variable when connecting to the database? When you are then I think you are always going throug the remotelink. I am not sure if you will get better performance while using beq or ipc.

Ton Raaijmakers

David Shi wrote:

> We have several instances on the same server, and use database link to
> copy tables among them ( or join local table with remote table ),
> using sqlnet through TCP/IP is very slow, even though all databases
> resides on the same local machine. I tried to setup Bequeth or IPC in
> sqlnet with the hoping of using local processes will speed up data
> transfer significantly, but I can't get it working - have also
> contacted Oracle tech support.
>
> Has anyone done this and can kindly provide me a sample of sqlnet
> configuration files?
>
> Environment is SUN 6500, solaris 2.6 and Oracle 8 & 8i.
>
> Thanks!
>
> David
>
> PS. it is appreciated if you can cc to my email dshi_at_bigfoot.com as I
> don't have access to news at work. Thanks.
Received on Mon Dec 20 1999 - 04:41:15 CST