The REPACK_THREAD_MAX Configuration Parameter

The REPACK_THREAD_MAX configuration parameter specifies an upper limit to the number of repack threads.

onconfig.std value

None

onconfig.xps value

None

range of values

Minimum = 0; Maximum = 2,147,483,647

takes effect

when the database server starts up (or else when the REPACK_THREAD_MAX parameter is defined using the onutil utility)

The value that you specify for the REPACK_THREAD_MAX parameter specifies the maximum number of repack threads that can run concurrently in all sessions of the database server. If a repack thread completes processing of a table, and no other repack requests are awaiting service, the thread exits and ends its session.

If this parameter is not set, the maximum number of repack threads defaults to 10. Setting the value to zero disables this feature. The upper limit of its range is orders of magnitude above the number of repack threads typically required by server instances with finite resources.