You're welcome, please let me know the
results.
It was news to me as well, that so much temp space
would be used in your type of parallel direct load insert...
Btw, you can use nologging hint as well in your DML
if you haven't already altered the target table to nologging.
Tanel.
|
Title: RE: Nosort parallel dml uses TEMP tablespace
- Nosort parallel dml uses TEMP tablespace Turner, Adrian A SITI-ITPSIE
- RE: Nosort parallel dml uses TEMP tables... Turner, Adrian A SITI-ITPSIE
- RE: Nosort parallel dml uses TEMP tables... Turner, Adrian A SITI-ITPSIE
- Re: Nosort parallel dml uses TEMP tables... Tanel Poder
- Re: Nosort parallel dml uses TEMP tables... Tanel Poder
- RE: Nosort parallel dml uses TEMP tables... Turner, Adrian A SITI-ITPSIE
- Tanel Poder