Re: direct path write temp

Minimising writes to temp is the best optimisation!

Do that by getting accurate estimates in your execution plans wherever possible and reducing poorly sized work areas - Trying to avoid multi pass executions - optimise where possible to be one pass and similarly one pass to be in memory.

 https://docs.oracle.com/en/database/oracle/oracle-database/18/refrn/V-SQL_WORKAREA.html#GUID-72AE8C0F-DC23-45BD-9589-25EBF490BF0E

https://docs.oracle.com/en/database/oracle/oracle-database/18/refrn/V-SQL_WORKAREA_ACTIVE.html#GUID-AA69DDA7-9A2A-4FF8-918A-387FCF684ABA

Cheers
Dominic
Sent from my iPhone

On 27 Sep 2018, at 18:47, Hameed, Amir <Amir.Hameed_at_xerox.com<mailto:Amir.Hameed_at_xerox.com>> 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

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