Re: Export problem

From: Richard <roxl_at_ozemail.com.au>
Date: 2000/05/26
Message-ID: <QlrX4.1957$N4.61130@ozemail.com.au>#1/1

> We use NT4.0 and Oracle 8.0.4.
> A data export with exp80 takes 2 minutes, even if the source
> table is empty. During the export NT apparently nearly
> completely stops responding to any user input.
> The problem seems to be related with the number of columns in
> the table (the table contains about 230 columns).
> What can be done?

Not sure what to try on this one apart from tuning the database in general. It should be faster than this. One thing to check (now that I think of it) - are you running this direct from an interactive session on the server? If so, I'd check to see what the foreground task boost is (if it's called that). NT should be set so that it doesn't give your session preferance over remote users...

Of course that may not be the problem - but it's worth a check. I think this setting is under control panel, in the "system" applet.

Next step is to tune your server I think... Check for paging, disk contention at the OS level, then examine Oracle stats I guess.

/Richard/ Received on Fri May 26 2000 - 00:00:00 CDT