Re: Oracle 7.3.2.3 import performance

Have you considered,

         Parralleling the import? Import your biggest tables as a separate import each. Do the remaining smaller tables as one import. You may want to setup separate rollback segments for each import. This will require you having the relevant rollback segment online prior to starting an import (all the rest should be offline so that oracle will "grab" the right rollback).

        Running without archive logging when loading the database. This will reduce the amount of IO.

        Ensuring the I/O is spread across multiple disks. separate temp and rb, index and table tablespaces. Also, online redo logs.

        Increase your databse buffers to as large as you can, DB_BLOCK parameter in init.ora.

        Importing the data first and building the indexes with the "unrecoverable" option of 7.3. You can do this by using import to create an index sql file. This will further reduce IO during the data load and Rollback won't be used when the indexes are built. Use 'import rows=n indexfile=indexes.sql ...'.

        Ensure that the online redo logs are big enough by checking that you are not getting the message "checkpoint not complete" in the alert file. This ensures the database is not checkpointing too frequently. You can drop the online logs after the import if you want different sizes.

        I hope this has helped.

Vince

Alan Downing <aldowning_at_email.msn.com> wrote in article <OvKhY1MS9GA.335_at_upnetnews02.moswest.msn.net>...
> I need to improve the time it takes to import data from 7.1.6 to 7.3.2.3
> Oracle on a Dynix/ptx platform. At present it is taking about 26 hours.
 The
> job must be done using tape as there is a space restriction on the
 servers
> disks. We have tried adjusting one or two of the parameter file settings
 but
> are now running out of time for experimentation as our new application,
> which only runs on 7.3.2.3, must be up and running by the 16th March.
>
> Can anyone help please?
>
> Alan
>
>
>
Received on Thu Mar 12 1998 - 00:00:00 CST