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@xxxxxxxxx<mailto:Amir.Hameed@xxxxxxxxx>> 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