Re: import performance

Try:

buffer=60000000
commit=y

HTH Guang

PJ <as1542_at_hotmail.com> wrote in message news:<rgra7u09f4lbqjmlcnd17gdmieajh2fq39_at_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 - 22:32:58 CST