"Charles J. Fisher" wrote:
>
> 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 /
> ---------------------------------------------------------------------------
Having autoextend on will slow things down a lot (depending on how often
the files extend). How big is your SGA? Is it at least the same (data
buffers) as the 8.0.5 instance? How often are you committing? How many
records are buffering?
You should not have to rereun catproc.sql.
--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Thu Oct 18 2001 - 09:57:30 CDT
