Document Type | Technical Information
Category | Administration
Applicable Product Versions | 6FS07, 6FS07PS, 7FS01, 7FS02, 7FS02PS
Document Number | TADTI011
Overview
In the Tibero database, each Background Process performs a unique role, and within a single process, there are Threads separated by work units.
- Typically, one process contains about 10 Threads.
- The number of Threads for a foreground process can be adjusted using the WTHR_PER_PROC parameter.
- Threads can be identified through the v$process view.
Method
Information that can be checked from DB Background Process
- Identify processes using the .proc.list file or the ps command.
- Check the roles and status of Threads within the process through v$process.
- Determine locking status or wait conditions using values such as LATCHWAIT.
How to Check the Process (PID)
1. Check the proc.list file
$ cat $TB_HOME/instance/$TB_SID/.proc.list Tibero 7 start at (2025-02-05 00:36:16) by 1032 shared memory: 139952569753600 size: 2147483648 shm_key: 274646987 1 sem_key: -1613880249 218 listener_pid: 94476 listener_port: 8857 listener_special_port: 8858 epa_pid: -1 94475 MONP 94477 MGWP 94478 FGWP0000 94479 FGWP0001 94480 FGWP0002 94481 PEWP0000 94482 PEWP0001 94483 PEWP0002 94484 PEWP0003 94485 PEWP0004 94486 PEWP0005 94487 AGNT 94488 DBWR 94489 RCWP
2. Using the ps command
PID: 94488 โ You can confirm this is the DBWR process.
$ ps -ef | grep svr viera 94475 1 0 Feb04 pts/1 00:00:39 tbsvr -t NORMAL -SVR_SID tibero viera 94477 94475 0 Feb04 pts/1 00:00:00 tbsvr_MGWP -t NORMAL -SVR_SID tibero viera 94478 94475 0 Feb04 pts/1 00:00:01 tbsvr_FGWP000 -t NORMAL -SVR_SID tibero viera 94479 94475 0 Feb04 pts/1 00:00:00 tbsvr_FGWP001 -t NORMAL -SVR_SID tibero viera 94480 94475 0 Feb04 pts/1 00:01:11 tbsvr_FGWP002 -t NORMAL -SVR_SID tibero viera 94481 94475 0 Feb04 pts/1 00:00:00 tbsvr_PEWP000 -t NORMAL -SVR_SID tibero viera 94482 94475 0 Feb04 pts/1 00:00:00 tbsvr_PEWP001 -t NORMAL -SVR_SID tibero viera 94483 94475 0 Feb04 pts/1 00:00:00 tbsvr_PEWP002 -t NORMAL -SVR_SID tibero viera 94484 94475 0 Feb04 pts/1 00:00:00 tbsvr_PEWP003 -t NORMAL -SVR_SID tibero viera 94485 94475 0 Feb04 pts/1 00:00:00 tbsvr_PEWP004 -t NORMAL -SVR_SID tibero viera 94486 94475 0 Feb04 pts/1 00:00:00 tbsvr_PEWP005 -t NORMAL -SVR_SID tibero viera 94487 94475 1 Feb04 pts/1 00:29:55 tbsvr_AGNT -t NORMAL -SVR_SID tibero viera 94488 94475 0 Feb04 pts/1 00:00:59 tbsvr_DBWR -t NORMAL -SVR_SID tibero viera 94489 94475 0 Feb04 pts/1 00:00:04 tbsvr_RCWP -t NORMAL -SVR_SID tibero
How to Check Threads for Background Processes
In Tibero, the v$process view allows you to check the list of Threads for a specific process (PID).
- SPID: Actual OS Process ID
- TID: Internal Thread ID
- NAME: Thread name (e.g., LGWR, DBWR, FARC, etc.)
SQL> select * from v$process where SPID=94488;
PID TID SPID NAME LATCHWAIT
---------- ---------- ---------- -------- ------------------
12 12 94488 DBWR 0x00
12 24 94488 LGWR 0x00
12 25 94488 LARC 0x00
12 26 94488 CKPT 0x00
12 27 94488 BLKW 0x00
12 28 94488 BLKW 0x00
12 29 94488 BLKW 0x00
12 30 94488 BLKW 0x00
12 31 94488 BLKW 0x00
12 41 94488 FBWR 0x00
12 42 94488 FARC 0x00
11 rows selected.