Change Number of Concurrent Model Builds

Building Mining Models can take considerable machine resources. To help address the level of resources consumed by these operations, The repository property MAX_NUM_THREADS controls the number of concurrent Mining Model Builds allowed to take place.

The default value of MAX_NUM_THREADS is 10. MAX_NUM_THREADS can either be raised or lowered depending on the system capabilities available and the mining model resource demands.

The following example shows how to increase the number of model builds to 15.

Execute this script:

set echo on;
-- value of MAX_NUM_THREADS before update
select property_name, property_num_value from ODMRSYS.ODMR$REPOSITORY_PROPERTIES
where property_name = 'MAX_NUM_THREADS';
-- update MAX_NUM_THREADS
UPDATE ODMRSYS.ODMR$REPOSITORY_PROPERTIES
SET property_num_value = 15
where property_name = 'MAX_NUM_THREADS';
-- commit change
commit;
-- value of MAX_NUM_THREADS after update
select property_name, property_num_value from ODMRSYS.ODMR$REPOSITORY_PROPERTIES
where property_name = 'MAX_NUM_THREADS';

The following log is produced when you run the script:

-- value of MAX_NUM_THREADS before update
 
select property_name, property_num_value from ODMRSYS.ODMR$REPOSITORY_PROPERTIES
where property_name = 'MAX_NUM_THREADS'
 
PROPERTY_NAME PROPERTY_NUM_VALUE
------------------------------ ----------------------
MAX_NUM_THREADS 10
 
-- update MAX_NUM_THREADS
 
UPDATE ODMRSYS.ODMR$REPOSITORY_PROPERTIES
SET property_num_value = 15
where property_name = 'MAX_NUM_THREADS'
 
1 rows updated
-- commit change
 
commit
 
commited
-- value of MAX_NUM_THREADS after update
 
select property_name, property_num_value from ODMRSYS.ODMR$REPOSITORY_PROPERTIES
where property_name = 'MAX_NUM_THREADS'
 
PROPERTY_NAME PROPERTY_NUM_VALUE
------------------------------ ----------------------
MAX_NUM_THREADS 15