如何查看各个session或thread占用的系统资源，如CPU，I/O等

zhizhi

如题

蓝色键盘

onstat系列命令。

如io
onstat -g iof
cpu
onstat -g glo
结合OS的

vmstat
top
iostat

zhizhi

原帖由 "蓝色键盘" 发表：
onstat系列命令。

如io
onstat -g iof
cpu
onstat -g glo
结合OS的

vmstat
top
iostat

   
谢谢，我的意思是想找到占用资源最多的访问IDS的session或者thread

蓝色键盘

偶给你个脚本
你区执行一下，显示的是准确的统计信息。

1. 
   
2. dbaccess  - -<<! 1>;chkiosum.out
   
3. database sysmaster;
   
4. select
   
5. name dbspace,
   
6. chknum,
   
7. "Primary" chktype,
   
8. reads,
   
9. writes,
   
10. pagesread,
    
11. pageswritten
    
12. from syschktab c, sysdbstab d
    
13. where c.dbsnum = d.dbsnum
    
14. union all
    
15. select
    
16. name[1,10] dbspace,
    
17. chknum,
    
18. "Mirror" chktype,
    
19. reads,
    
20. writes,
    
21. pagesread,
    
22. pageswritten
    
23. from syschktab c,sysdbstab d
    
24. where c.dbsnum = d.dbsnum
    
25. into temp A;
    
26. select
    
27. sum(reads) total_reads,
    
28. sum(writes) total_writes,
    
29. sum(pagesread) total_pgreads,
    
30. sum(pageswritten)  total_pgwrites
    
31. from A
    
32. into temp B;
    
33. select
    
34. dbspace,
    
35. chknum,
    
36. chktype,
    
37. reads,
    
38. writes,
    
39. pagesread,
    
40. pageswritten,
    
41. round((reads/total_reads)*100,2 )  percent_reads,
    
42. round((writes/total_writes)*100,2 )  percent_writes,
    
43. round((pagesread/total_pgreads)*100,2 )  percent_pgreads,
    
44. round((pageswritten/total_pgwrites)*100,2 )  percent_pgwrites
    
45. from A,B
    
46. order by 11;
    
47. !
    

复制代码