Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Exceptionally slow 9.2 import
Hi, I'm trying to import database onto my 9.2 Personal Server on
Windows XP Pro to debug a specific problem for a client. The backup
file I'm restoring is not huge (approx. 60Mb), neither are the
tablespaces into which the data is being restored - 150Mb and 450Mb.
On my previous machine (1GHz PIII processor, 512Mb RAM, Personal Server
8) I don't ever remember such an operation taking more than 30 minutes.
However, on my newer machine (1.6GHz P4 processor, 1Gb RAM, Personal
Server 9) it takes hours and hours - I left it running overnight, and
hadn't even completed by the middle of the next morning.
When I examine my system's resources, I see that the Imp and Oracle processes are using somewhere from 0-4% CPU time and 1Mb / 125Mb memory respectively. Increasing the priority of the processes makes no difference.
If anyone has any ideas as to what could be causing this, I'd be very, very grateful!
TIA Received on Fri Mar 11 2005 - 07:24:07 CST
![]() |
![]() |