gibboniser_at_gmail.com wrote:
> 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
What resources are maxed out? It is waiting for something.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Fri Mar 11 2005 - 10:42:12 CST
