Re: Import time taking so long <<<===============================================================

A Ustby wrote:

> Another Oracle question/observation....
>
> We have an instance (v7.3.3) that has 1000+ tables in it (purchased
> application). A couple of the tables have 1.5 million rows in them. One of
> these tables has 14 indexes on it. On the same box we run both production and
> test instances. We have the Oracle parameters (memory, sort area, etc) set
> lower for the test instance. When we load production instance, it takes 17
> hours. When we load the same data into the test instance, it takes 41 hours.
> Both loads were done when the box was quiet.
>
> We are using the Oracle import utility. It appears the excess time is in the
> index build phase. Could this be affected (that much !) by the Oracle sort parm
> size ? Any other insight ?

Yes, it can. I've seen the build performance of indexes drop dramatically when sort areas are reduced. You'll see a much higher degree of temp tablespace activity.

>
>
> The thing takes so long, we haven't done too much experimenting.

It's not experimenting you need. It's *monitoring*. Next time you run the imports use some proper tools to monitor Oracle and your server (disks, memory and CPU) and it's OS so you *know* where the bottleneck is - anything else is just guesswork.

>
>
> Thanks.......... Art

Steve Phelan

(Oracle 7 & 8 OCP) Received on Mon Feb 22 1999 - 16:36:42 CST