Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Use Bequeth or IPC protocol to speed up large table copy between instances on the same server?

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

From: David Shi <dshi_at_bigfoot.com>
Date: Sat, 18 Dec 1999 13:46:03 GMT
Message-ID: <385b8e7e.260674@news.earthlink.net>


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 Sat Dec 18 1999 - 07:46:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US