How To Setup Saexpgl Batch In Multithread (Doc ID 2816858.1)

Last updated on MAY 25, 2023

Applies to:

Goal

How to setup saexpgl batch to work in multithread?

Set up restart_control.num_threads =4 and also had added corresponding number of records in the restart_progress_status table for saexpgl to run the batch in multi-thread mode.

The batch is taking almost the same time when it's run with 1 thread and in 4 threads.

Number of threads=1
Start Time - 7/29/2021 2:08:09 AM CDT
Finish Time - 7/29/2021 2:12:38 AM CDT
Duration(hh:mm:ss) - 00:04:29

Number of threads=4
Start Time - 7/29/2021 7:36:46 AM CDT
Finish Time - 7/29/2021 7:41:23 AM CDT
Duration(hh:mm:ss) - 00:04:37

On checking saexpgl batch, we find the cursor c_store_day_to_be_exported_gl in the library Pro* C batch fetchStoreDayToBeExportedGL.pc (invoked by saexpgl batch), uses a MOD function on number of threads and thread_val in the 'Order By' clause of the cursor select query.

Apart from that, the cursor query does not have the standard reference to the v_restart_store view which other multi-threaded batch like saexprms (based on location multi-threading) use.

Please confirm that saexpgl batch can be run in multi-thread mode; if not, then provide the fix/code which allows saexpgl batch to run in multi-thread.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.