请教贴 onstat -u

foxyzhou

onstat  -u 输出结果中第二栏位的旗标各个字母所代表的含义？

liaosnet

原帖由 foxyzhou 于 2010-1-7 17:42 发表
onstat  -u 输出结果中第二栏位的旗标各个字母所代表的含义？

1. 
   
2. Describes the status of the userthread using the following coded values:
   
3. 
   
4. Position 1:
   
5.         B        Waiting on a buffer
   
6.         C        Waiting on a checkpoint
   
7.         G        Waiting on write of the Logical Log                         buffer
   
8.         L        Waiting on a lock
   
9.         S        Waiting on a mutex
   
10.         T        Waiting on a transaction
    
11.         X        Waiting on a transaction cleanup
    
12.         Y        Waiting on a condition
    
13. 
    
14. Position 3:
    
15.         A        DBSpace backup thread
    
16.         B        Begin work
    
17.         P        Preparing/prepared
    
18.         X        XA prepare
    
19.         C        Commiting/committed
    
20.         R        Aborting/aborted
    
21.         H        Heuristic aborting/aborted
    
22. 
    
23. Position 4:
    
24.         P        Primary thread for a session
    
25. 
    
26. Position 5:
    
27.         R        Reading (RSAM Call)
    
28.         X        Critical Write
    
29. 
    
30. Position 7:
    
31.         B        BTree clean thread
    
32.         C        Terminated user thread waiting for                         cleanup
    
33.         D        Daemon thread
    
34.         F        Page cleaner thread (flusher)
    
35.         M        On-Monitor thread
    

复制代码

foxyzhou

THANKS