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

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 22 Dec 1999 15:03:45 -0000
Message-ID: <945875272.14039.2.nnrp-11.9e984b29@news.demon.co.uk>

Assuming the copy is being done in the best possible way (nologging CTAS, or copy command with commits), then you may be able to increase the pipeline between servers with a BEQ entry like this: (oracle 8.1)

ins2.world =

    (description=

        (sdu=32768)
        (tdu=32768)
        (address=
            (protocol = beq)
            (program = oracle)
            (argv0 = oracleins2)
            (args = '(description=(local=yes)(address=(protocol=beq)))')
        )
        (connect_data=
            (sid=ins2)
        )

    )

You may need to use the full path name of oracle in the 'program=' line You may need to add

    (envs='ORACLE_HOME=xxxxxxxxx,ORACLE_SID=ins2') after the args line

NB Change ins2 to your SID

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

dshi wrote in message <0b90d704.2de65a09_at_usw-ex0101-003.remarq.com>...
>
>Thanks for your information. The main problem is that when copy a, say,
>20 GB table from one database to another database ( eg: from test db to
>production or verse versa ), the db link is very slow, compare to, say,
>dump the table out and do direct sql load back, even both DB is local.
>
Received on Wed Dec 22 1999 - 09:03:45 CST