SET_THREAD_COUNT

Last Updated:2026-09-04 11:28:25

The SET_THREAD_COUNT procedure is used to set the number of threads for window compaction.

Syntax

DBMS_DAILY_MAINTENANCE.SET_THREAD_COUNT(thread_count INT);

Parameter	Description
thread_count	Specifies the number of threads for window compaction. The default value is 0, which means that the system adaptively calculates the number of threads for window compaction based on tenant-related configurations. If a non-zero value is manually specified, the system uses the specified value as the number of threads for window compaction.

Only user tenants can initiate this operation. System tenants (such as the sys tenant) do not support it.
During window compaction, the number of threads is not controlled by the tenant-level parameter compaction_low_thread_score. It can only be set through the thread_count parameter in the DBMS_DAILY_MAINTENANCE.SET_THREAD_COUNT procedure.

Set the number of threads for window compaction to 10.

obclient(sys@oracle001)[SYS]> CALL DBMS_DAILY_MAINTENANCE.SET_THREAD_COUNT(10);

Set the number of threads for window compaction to the value calculated adaptively by the system.
```
obclient(sys@oracle001)[SYS]> CALL DBMS_DAILY_MAINTENANCE.SET_THREAD_COUNT(0);
```

For more information about window compaction and related operations, see Window compaction.

Previous topic

Next topic