等待事件“inactivesession”剖析过程。 - 数据库编程

TOP

等待事件“inactivesession”剖析过程。(四)

2014-11-24 00:37:36 来源: 作者: 【大中小】浏览:71次

1596 alter system kill session '953,26108' 1036 26790 2843 Rhys_rhys_rhys_ rhysrh1 2014-03-08 0.07027777 INACTIVE orakill 1036 26790 alter system kill session '1036,2843' 1057 28815 16184 RHYSRH rhysrh1 2014-03-08 0.17444444 INACTIVE orakill 1057 28815 alter system kill session '1057,16184' 1045 28817 1587 RHYSRH rhysrh1 2014-03-08 0.17444444 INACTIVE orakill 1045 28817 alter system kill session '1045,1587' 1061 28821 3027 Rhys_rhys_rhys_ rhysrh1 2014-03-08 0.17444444 INACTIVE orakill 1061 28821 alter system kill session '1061,3027' 1005 24514 447 RHYSRH rhysrh1 2014-03-09 0.03361111 INACTIVE orakill 1005 24514 alter system kill session '1005,447' SID SPID SERIAL# LOCKWAIT USERNAME OSUSER LOGON_TIME LAST_HOUR STATUS HOST_COMMAND SQL_COMMAND ---------- ------------ ---------- ---------------- ------------------------------ ------------------------------ ----------- ---------- -------- ------------------------------------------------------------- -------------------------------------------------------------------------------- 943 10000 29091 Rhys_rhys_rhys_ unicom 2014-03-21 0.35944444 INACTIVE orakill 943 10000 alter system kill session '943,29091' 973 12224 14955 Rhys_rhys_rhys_ rhysrh1 2014-03-21 0.00416666 INACTIVE orakill 973 12224 alter system kill session '973,14955' 999 12185 9626 Rhys_rhys_rhys_ rhysrh1 2014-03-21 0.00333333 INACTIVE orakill 999 12185 alter system kill session '999,9626' 984 7305 51145 Rhys_rhys_rhys_ rhysrh1 2014-03-18 18.0855555 INACTIVE orakill 984 7305 alter system kill session '984,51145' 1002 9657 20151 Rhys_rhys_rhys_ dum 2014-03-21 0.57638888 INACTIVE orakill 1002 9657 alter system kill session '1002,20151' 998 12257 15458 Rhys_rhys_rhys_ rhysrh1 2014-03-21 0 INACTIVE orakill 998 12257 alter system kill session '998,15458' 970 12153 40388 Rhys_rhys_rhys_ rhysrh1 2014-03-21 0.00555555 INACTIVE orakill 970 12153 alter system kill session '970,40388' 963 10116 56760 Rhys_rhys_rhys_ rhysrh1 2014-03-21 0.13277777 INACTIVE orakill 963 10116 alter system kill session '963,56760' 1072 12891 58537 PMS_PORT root 2014-03-13 201.3425 INACTIVE orakill 1072 12891 alter system kill session '1072,58537' 1076 23539 852 Rhys_rhys_rhys_ rhysrh1 2014-03-07 18.0855555 INACTIVE orakill 1076 23539 alter system kill session '1076,852' 1019 12117 6100 Rhys_rhys_rhys_ rhysrh1 2014-03-21 0.01166666 INACTIVE orakill 1019 12117 alter system kill session '1019,6100' 1009 12204 54434 Rhys_rhys_rhys_ rhysrh1 2014-03-21 0.00027777 INACTIVE orakill 1009 12204 alter system kill session '1009,54434' 1030 21449 3 Rhys_rhys_rhys_ rhysrh1 2014-03-07 0.3275 INACTIVE orakill 1030 21449 alter system kill session '1030,3' 1022 26841 2 Rhys_rhys_rhys_ rhysrh1 2014-03-08 0.6675 INACTIVE orakill 1022 26841 alter system kill session '1022,2' 1044 24512 29852 RHYSRH rhysrh1 2014-03-09 0.03361111 INACTIVE orakill 1044 24512 alter system kill session '1044,29852' 954 9392 42267 Rhys_rhys_rhys_ rhysrh1 2014-03-21 0.40777777 INACTIVE orakill 954 9392 alter system kill session '954,42267' 982 12214 4240 Rhys_rhys_rhys_ rhysrh1 2014-03-21 0.00277777 INACTIVE orakill 982 12214 alter system kill session '982,4240' 971 12187 64974 Rhys_rhys_rhys_ rhysrh1 2014-03-21 0.00277777 INACTIVE orakill 971 12187 alter system kill session '971,64974' 1035 9630 56921 Rhys_rhys_rhys_ dum 2014-03-21 0.58 INACTIVE orakill 1035 9630 alter system kill session '103

首页上一页 1 2 3 4 5 6 7 下一页尾页 4/8/8
【大中小】【打印】【繁体】【投稿】【收藏】【推荐】【举报】【评论】【关闭】【返回顶部】
分享到:
上一篇：machinelearning之梯度下降（bgd\..	下一篇：SSAS下玩转PowerShell（二）

帐　　号:

密码: (新用户注册)

验证码:

表　　情:

内　　容: