Document Type | Technical Information
Category | Administration
Applicable Product Version | T6, T7
Document Number | TADTI128
Overview
This document explains parameters related to processes.
Method
- DBWR_CNT
DBWR_CNT specifies the number of threads that use the database blocks on the disk.
Only one process can be used.
Detailed information about the DBWR_CNT parameter is as follows.
| Category | Description |
| Type | Integer |
| Default Value | !_ENABLE_MULTI_DBWR ? 1 : MAX(1, get_ncpu()/4) (Configurable values: 1~1024) |
| Attributes | Optional, Adjustable, Static, System |
| Configuration Method | Set the TIP file and then restart. |
| Syntax | - TIP file DBWR_CNT = <set number> |
2. PEP_PROC_CNT
This parameter sets the number of PE (Parallel Execution) processes.
Detailed information about the PEP_PROC_CNT parameter is as follows.
| Category | Description |
| Type | Integer |
| Default Value | 6 (Configurable values: 0~10000) |
| Attributes | Optional, Adjustable, Static, System |
| Configuration Method | Set the TIP file and then restart. |
| Syntax | - TIP file PEP_PROC_CNT = <set number> |
3. RECO_PROC_WTHR_CNT
This parameter sets the number of recovery process threads.
Detailed information about the RECO_PROC_WTHR_CNT parameter is as follows.
| Category | Description |
| Type | Integer |
| Default Value | 35 + _CACHE_RECO_DOP (Configurable values: 1~INT32_MAX) |
| Attributes | Optional, Adjustable, Static, System |
| Configuration Method | Set the TIP file and then restart. |
| Syntax | - TIP file RECO_PROC_WTHR_CNT = <set number> |
4. WTHR_PER_PEP
This parameter sets the number of worker threads per PE (Parallel Execution) process (PEP).
Detailed information about the WTHR_PER_PEP parameter is as follows.
| Category | Description |
| Type | Integer |
| Default Value | 16 (Configurable values: 1~10000) |
| Attributes | Optional, Adjustable, Static, System |
| Configuration Method | Set the TIP file and then restart. |
| Syntax | - TIP file WTHR_PER_PEP = <set number> |
5. WTHR_PER_PROC
This parameter sets the number of threads within a worker process.
Detailed information about the WTHR_PER_PROC parameter is as follows.
| Category | Description |
| Type | Integertr data-id="149"Default Value10 (Configurable values: 1~10000) |
| Attributes | Optional, Adjustable, Static, System |
| Configuration Method | Set the TIP file and then restart. |
| Syntax | -id="161"WTHR_PER_PROC = <set number> |
6. WTHR_PROC_CNT
This parameter sets the number of worker processes.
Detailed information about the WTHR_PROC_CNT parameter is as follows.
| Category | Description |
| Type | Integer |
| Default Value | MAX_SESSION_COUNT/WTHR_PER_PROC (Configurable values: 1~10000) |
| Attributes | Optional, Adjustable, Static, System |
| Configuration Method | Set the TIP file and then restart. |
| Syntax | - TIP file WTHR_PROC_CNT = <set number> |
7. WTHR_PROC_CNT_MAX
This parameter sets the maximum number of worker processes.
When the RDBMS starts, the number of worker processes defined in WTHR_PROC_CNT is implemented.
If the number of worker processes becomes insufficient during RDBMS operation, the number of worker processes will increase within the limit specified by this parameter.
If the WTHR_PROC_CNT_MAX parameter is set to its default value, the number of worker processes defined in WTHR_PROC_CNT will be used as the maximum number of running processes.
Detailed information about the WTHR_PROC_CNT_MAX parameter is as follows.
| Category | Description |
| Type-id="211"Integer | |
| Default Value | WTHR_PROC_CNT (Configurable values: 1~10000) |
| Attributes | Optional, Adjustable, Static, System |
| Configuration Method | Set the TIP file and then restart. |
| Syntax | - TIP file WTHR_PROC_CNT_MAX = <set number> |