-
Select 'alter system kill session ' || Chr(39) || a.Sid || ',' || a.Serial# ||
-
Chr(39) || ' immediate' Sql,
-
a.Program,
-
b.Ip
-
From Gv$session a,Zlclients b
-
Where a.Terminal = b.工作站
-
And Upper(a.Program) In ('ZL9LABPRINTSVR.EXE',
-
'ZL9LABRECEIV.EXE',
-
'ZL9LABTCPSVR.EXE',
-
'ZL9LISCOMM.EXE',
-
'ZL9WIZARDMAIN.EXE',
-
'ZLACTMAIN.EXE',
-
'ZLHIS+.EXE',
-
'ZLHISCRUST.EXE',
-
'ZLLISRECEIVESEND.EXE',
-
'ZLNEWQUERY.EXE',
-
'ZLORCLCONFIG.EXE',
-
'ZLPACSBROWSERSTATION.EXE',
-
'ZLPACSSRV.EXE',
-
'ZLPEISAUTOANALYSE.EXE',
-
'ZLRPTSQLADJUST.EXE',
-
'ZLRUNAS.EXE',
-
'ZLSVRNOTICE.EXE',
-
'ZLSVRSTUDIO.EXE',
-
'ZLWIZARDSTART.EXE',
-
'VB6.EXE')
-
And (a.Terminal <> Userenv('terminal') Or
-
a.Terminal = Userenv('terminal') And
-
Upper(a.Program) Not In ('VB6.EXE', 'ZLSVRSTUDIO.EXE'))
- Order By a.Terminal, a.Program
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28878983/viewspace-2133931/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
删除用户和表空间
请登录后发表评论
登录
全部评论
