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 -> Importing on Linux is SO SLOW.

Importing on Linux is SO SLOW.

From: Charles J. Fisher <cfisher_at_rhadmin.org>
Date: Thu, 18 Oct 2001 14:30:01 GMT
Message-ID: <Pine.LNX.4.33.0110180920400.1727-100000@galt.rhadmin.org>


I haven't had time for adequate performance-testing yet, but attempting to move a Siebel schema from HPUX 10.20/Oracle 8.0.5 to SUSE Linux/Oracle 8.1.7 is taking FOREVER - the export piped to gzip took a little over three hours, but the import has now taken over a day and it's only 1/3 done.

Would setting "AUTOEXTEND ON" for the datafiles slow things down? I had a reasonably fast import of the development data, but it was smaller.

Also, if I do a full import to Linux, do I have to rerun catalog.sql and catproc.sql?

Sizes:

prdcrm2:/home/oracle # gzip -l devcrm.exp.gz siebel.exp.gz

         compressed        uncompressed  ratio uncompressed_name
           53529593           627102720  91.4% devcrm.exp
          279769621          3032629248  90.7% siebel.exp
          333299214          3659731968  90.8% (totals)

    ---------------------------------------------------------------------------
   / Charles J. Fisher                   |"How many who came into this world /
  /  cfisher_at_rhadmin.org                 | with me have already left it!"   /
 /   http://rhadmin.org:81               |       -Marcus Aurelius          /
---------------------------------------------------------------------------
Received on Thu Oct 18 2001 - 09:30:01 CDT

Original text of this message

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