declare
ora_user varchar2(30) default 'SCOTT';
begin
execute immediate 'alter user '||ora_user||' account lock';
for crs in (select sid,serial# from v$session where username = ora_user) loop
execute immediate 'alter system kill session '''||crs.sid||','||crs.serial#||'''';
end loop;
end;
/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/38542/viewspace-914205/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
hint的30种用法
下一篇：
什么是并行查询及其原理
请登录后发表评论
登录
全部评论
-
博文量235
-
访问量1707861
最新文章
- Two errors after cloning eBS
- An error from listener
- How to change the APPS db password in Oracle EBS
- Management on database link
- Three ways to quickly login into EBS 11i
- SMART Goal Setting
- A good template email on how to apply for training program
- 4C
- My understanding of AD configuration
- Taught Oracle database OCP training course
