Monitor threads with onstat -g cpu output
Use the onstat –g cpu command to display the last time the thread ran, how much CPU time the thread used, the number of times the thread ran, and other statistics about all the threads running in the server
The following output example shows the ID and name of each thread that is running, the ID of the virtual processor in which each thread is running, the day and time when each thread last ran, how much CPU time each thread used, the number of times each thread was scheduled to run, and the status of each thread.
Thread CPU Info:
tid name vp Last Run CPU Time #scheds status
2 lio vp 0 3lio* 07/18 08:35:35 0.0000 1 IO Idle
3 pio vp 0 4pio* 07/18 08:35:36 0.0102 2 IO Idle
4 aio vp 0 5aio* 07/18 08:35:47 0.6876 68 IO Idle
5 msc vp 0 6msc* 07/18 11:47:24 0.0935 14 IO Idle
6 main_loop() 1cpu* 07/18 15:02:43 2.9365 23350 sleeping secs: 1
7 soctcppoll 7soc* 07/18 08:35:40 0.1150 1 running
8 soctcpio 8soc* 07/18 08:35:40 0.0037 1 running
9 soctcplst 1cpu* 07/18 11:47:24 0.1106 10 sleeping forever
10 soctcplst 1cpu* 07/18 08:35:40 0.0103 6 sleeping forever
11 flush_sub(0) 1cpu* 07/18 15:02:43 0.0403 23252 sleeping secs: 1
12 flush_sub(1) 1cpu* 07/18 15:02:43 0.0423 23169 sleeping secs: 1
13 flush_sub(2) 1cpu* 07/18 15:02:43 0.0470 23169 sleeping secs: 1
14 flush_sub(3) 1cpu* 07/18 15:02:43 0.0407 23169 sleeping secs: 1
15 flush_sub(4) 1cpu* 07/18 15:02:43 0.0307 23169 sleeping secs: 1
16 flush_sub(5) 1cpu* 07/18 15:02:43 0.0323 23169 sleeping secs: 1
17 flush_sub(6) 1cpu* 07/18 15:02:43 0.0299 23169 sleeping secs: 1
18 flush_sub(7) 1cpu* 07/18 15:02:43 0.0314 23169 sleeping secs: 1
19 kaio 1cpu* 07/18 14:56:42 1.4560 2375587 IO Idle
20 aslogflush 1cpu* 07/18 15:02:43 0.0657 23166 sleeping secs: 1
21 btscanner_0 1cpu* 07/18 15:00:53 0.0484 784 sleeping secs: 61
37 onmode_mon 1cpu* 07/18 15:02:43 0.3467 23165 sleeping secs: 1
43 dbScheduler 1cpu* 07/18 14:58:14 1.6613 320 sleeping secs: 31
44 dbWorker1 1cpu* 07/18 13:48:10 0.4264 399 sleeping forever
45 dbWorker2 1cpu* 07/18 14:48:11 1.9346 2936 sleeping forever
94 bf_priosweep() 1cpu* 07/18 15:01:42 0.0431 77 cond wait bp_cond