Oracle Exchange Partition Perfomance issue

65 Views Asked by At

When I set exchange partition ( auto dop is open), I notice multiblock reading in session events and exchange partition process takes too much time.. But if I set manual dop, job is completed earlier. i tried Parallel_min_threshold=0 and 1 as a result of this i couldnt solve problem.

Other paramters: _parallel_cache_policy=Adaptive

_serial_direct_read=AUTO

In addition: query and etl jobs works properly..(Cell smart table scan) there was only one problem about exchange partition.

Whould you please give your suggestion on this problem.

Solutions and direction

1

There are 1 best solutions below

0
John_sw On

I changed _serial_direct_read as ALWAYS then problem is solved