Re: Disk Space Transaction wait event

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Sun, 25 Feb 2001 09:35:17 GMT
Message-ID: <3a98cef1.3117934@news-server>

On Sun, 25 Feb 2001 04:55:07 GMT, robertch_at_mindspring.com (Robert Chung) wrote:

>
>
>I am trying to import several export files at the same time to a empty
>Oracle 8.1.6 database running on Sun Solaris. However, these import
>sessions are running absolutely slow. . . They are mostly waiting on
>Disk Space Transaction wait event. Does anybody know how to alleviate
>it? Thank you in advance
>

Do an import first with rows=n,indexes=n,grants=n. That will allocate the tables in one go and put no data there. Now do the parallel imports with rows=y, indexes=n, grants=n. Once all the data is in, do an import also in parallel with rows=n, indexes=y, grants=y.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Sun Feb 25 2001 - 03:35:17 CST