import performance

From: PJ <as1542_at_hotmail.com>
Date: Thu, 21 Feb 2002 22:13:59 GMT
Message-ID: <rgra7u09f4lbqjmlcnd17gdmieajh2fq39@4ax.com>

Hello,

I have been reading previous posts about imports that are slow. I am still having trouble and support is not helping. maybe you have seen this problem.

Here is my situation:
SunSolaris2.8 4x750Mhz 8Gb RAM, 2Gb SGA Oracle 8.1.7, 8.1.6 export the import hangs here...

Export file created by EXPORT:V08.01.06 via conventional path import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
. importing PERFSTAT's objects into PERFSTAT It hangs here for a really long time
then, moves along when it starts importing rows.

But at the O/S, there are tons of "page outs", but not alot of CPU usage. I have huge redologs.

Here is my import parfile:

ignore=y fromuser=PERFSTAT touser=PERFSTAT analyze=n buffer=1024000 commit=n

Thanks in advance Received on Thu Feb 21 2002 - 16:13:59 CST