onstat -g cpu: Print runtime statistics

Use the onstat -g cpu command to display information about runtime statistics for each thread that is running in the server.


Syntax:

>>-onstat-- -g--cpu--------------------------------------------><

Example output

Figure 1. onstat -g cpu command output

onstat -g cpu

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

Output description

tid

The ID of the thread

name

The name of the thread

vp

The ID of the virtual processor in which the thread is running

Last Run

The timestamp when the thread last ran

CPU Time

The time taken until now by the thread

#scheds

The number of times the thread was scheduled to run

status

The status of the thread. Possible status values are:

cond wait
IO Idle
join wait
mutex wait
ready
sleeping
terminated
running
yield