Re: Poor IMP Performance 8.1.7.2, Win 2000

From: Stephan Bressler <stephan.bressler_at_siemens.com>
Date: Tue, 11 Jun 2002 09:14:46 +0200
Message-ID: <ae4818$btb$1@news.mch.sbs.de>

Hi,

you should look at v$session_wait in order to determine what your import is waiting for.
Beside that, 32k log_buffer is very small (set to 512k) and 64k sort_areas are too small (set to >1M if possible). Check for size of your logfiles and frequency of log switches.

Stephan

"EE" <silSPverAMback_at_photSPoAMbooks.com> wrote in message news:3d05090b.621472937_at_news.service.emory.edu...
> Hello experts,
>
> I am seeing what I consider poor performance/pauses on a schema
> import. We are seeing 1 hour for an import of a 450 MB total DMP file
> (by schema). Total database space involved in the import is under 2 GB
> (data + index).
>
> I am used to the UNIX world, so I am not sure what is reasonable for
> M$. Please let me know what you think, and any tuning hints.
>
> No, I can not change OS or shoot the vendor. Sad.
>
> thanks,
>
Received on Tue Jun 11 2002 - 02:14:46 CDT