Re: Disk Space Transaction wait event

If you use locally managed tablespace and temporary tablespace for sorting, you will not see this and you can run them in parallel.

Anjo.

Nuno Souto wrote:

> 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 - 06:32:49 CST