Re: import performance

Hello there,

depending on the kind of objects in this export file i would guess that there are a lot of stored procedure in there which are imported first.

I keep an eye on my imports by doing a  

   select owner, count(*)
   from sys.dba_objects
   where owner not in ('SYS','SYSTEM')

during the import.

I have one owner that has about 5000 stored procedures in his shema and only a few other database objects.
It takes more than an hour until the import shows any imported rows ...

Bye,

Andreas

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 Fri Feb 22 2002 - 02:08:03 CST