Re: direct path write temp

No parameter controls temporary direct writes. If the hash or sort doesn't fit in available PGA memory, the surplus  will be written to the temporary tablespace. And that's about it. So, don't use sort or hash joins. Another method of avoiding writing to the temp is using in-memory option, but that will cost you a pretty penny.

Regards

On 09/27/2018 01:13 PM, Hameed, Amir wrote:
>
> Hi,
>
> I am trying to find out what database parameter controls the size of
> *direct path write temp* and is there way to optimize it. You feedback
> will be appreciated.
>
> Thank you,
>
> Amir
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l