You can customize the parallel DSI thread environment.
Use these configuration parameters with alter connection to tune parallel DSI threads for individual connections.
To configure a connection for parallel DSI, set the parallel_dsi parameter to on and then set individual parallel DSI configuration parameters to fine-tune your environment.
alter connection to SYDNEY_DS.pubs2 set parallel_dsi to 'on'