Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Importing on Linux is SO SLOW.
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
![]() |
![]() |