Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Disk Space Transaction wait event
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