[Tibero] 티베로(tibero) - 프로세스 세션 확인

 

 tbboot하여 세션으로 연결된 프로세스를 확인하는 방법에는 2가지가 있습니다.

 

•  OS level : ps -ef | grep tbsvr
•  SQL : SELECT * FROM V$SESSION

 

 OS level에서 ps 명령어를 사용하여 조회하는 경우와 SQL로 딕션어리를 조회하는 방법의 예시입니다.

---

 

1. OS level의 ps 명령어

 

[tibero@T1:/tibero/edu/tibero6/instance/tibero]$ tbboot
Change core dump dir to /tibero/edu/tibero6/bin/prof.
Listener port = 8629

Tibero 6

TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NORMAL mode).
[tibero@T1:/tibero/edu/tibero6/instance/tibero]$ ps -ef | grep tbsvr
tibero    8535     1 13 14:18 pts/1    00:00:00 tbsvr          -t NORMAL -SVR_SID tibero
tibero    8537  8535  0 14:18 pts/1    00:00:00 tbsvr_MGWP     -t NORMAL -SVR_SID tibero
tibero    8538  8535  0 14:18 pts/1    00:00:00 tbsvr_FGWP000  -t NORMAL -SVR_SID tibero
tibero    8539  8535  2 14:18 pts/1    00:00:00 tbsvr_FGWP001  -t NORMAL -SVR_SID tibero
tibero    8540  8535  0 14:18 pts/1    00:00:00 tbsvr_PEWP000  -t NORMAL -SVR_SID tibero
tibero    8541  8535  0 14:18 pts/1    00:00:00 tbsvr_PEWP001  -t NORMAL -SVR_SID tibero
tibero    8542  8535  0 14:18 pts/1    00:00:00 tbsvr_PEWP002  -t NORMAL -SVR_SID tibero
tibero    8543  8535  0 14:18 pts/1    00:00:00 tbsvr_PEWP003  -t NORMAL -SVR_SID tibero
tibero    8544  8535 24 14:18 pts/1    00:00:00 tbsvr_AGNT     -t NORMAL -SVR_SID tibero
tibero    8545  8535  2 14:18 pts/1    00:00:00 tbsvr_DBWR     -t NORMAL -SVR_SID tibero
tibero    8546  8535  3 14:18 pts/1    00:00:00 tbsvr_RCWP     -t NORMAL -SVR_SID tibero
tibero    8653 18629  0 14:18 pts/1    00:00:00 grep --color=auto tbsvr

 

 

---

 2. SQL 딕션어리 조회

 

SQL> connect tibero/tmax
Connected to Tibero.

SQL> COL USERNAME FOR A20
SQL> SELECT SID, SERIAL#, USERNAME FROM V$SESSION;

       SID    SERIAL# USERNAME
---------- ---------- --------------------
        63        242 TIBERO
        64        300 SYS

2 rows selected.