ora-01940处理(杀session解锁)
来源:互联网 发布:盐城大数据产业园详址 编辑:程序博客网 时间:2024/06/06 03:06
SQL> select username,sid,serial# from v$session;
USERNAME SID SERIAL#
------------------------------ ---------- ----------
SYS 10141 53
ADRIANO 10234,24
已选择2行。
SQL> alter system kill session'10234,24';
系统已更改。
SQL> drop user ADRIANO cascade;
先杀session之后,再删除用户对象
select sess.sid,
sess.serial#,
lo.oracle_username,
lo.os_user_name,
ao.object_name,
lo.locked_mode
from v$locked_object lo,
dba_objects ao,
v$session sess
where ao.object_id = lo.object_id and lo.session_id = sess.sid;
SELECT *
FROM V$SESSION s, sys.x$kglob o, sys.x$kglpn p
WHERE upper(o.kglnaobj) LIKE upper('%不能编译的包体%')
AND p.kglpnhdl = o.kglhdadr
AND s.SADDR = p.kglpnuse;
select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID;
alter system kill session '144,46679' ;
SELECT * FROM V$DB_OBJECT_CACHE WHERE OWNER='TJSPFMS2008_LOGIN' AND LOCKS !='0';
SELECT SID,SERIAL#,PADDR FROM V$SESSION WHERE SID=385
SELECT SPID FROM V$PROCESS WHERE ADDR='0000000269230498'
再一次查询目前锁定的对象,若发现以上方法不能解除锁定的表,则用以下方法:
- ora-01940处理(杀session解锁)
- ORA-01102 处理(转载)
- ORA-28000 用户被锁解锁
- ORA-28000账户被锁和解锁
- ORA-28000 用户被锁解锁
- ORA-28000账户被锁和解锁
- ORA-00031: session marked for kill 处理Oracle中杀不掉的锁
- ORA-00031: session marked for kill 处理Oracle中杀不掉的锁
- ORA-00031: session marked for kill 处理Oracle中杀不掉的锁
- ORA-00031: session marked for kill 处理Oracle中杀不掉的锁
- ORA-00031: session marked for kill 处理Oracle中杀不掉的锁
- ORA-00031: session marked for kill 处理Oracle中杀不掉的锁
- ORA-00031: session marked for kill 处理Oracle中杀不掉的锁
- ora-00031:session marked for kill处理oracle中杀不掉的锁
- ora-00031:session marked for kill处理oracle中杀不掉的锁
- ora-00031:session marked for kill处理oracle中杀不掉的锁
- ora-00031:session marked for kill处理oracle中杀不掉的锁
- ora-00031:session marked for kill处理oracle中杀不掉的锁
- linux chmod命令参数及用法详解--文件文件夹权限设定命令
- “AndroidManifest.xml 系统找不到指定的文件”解决方案
- 解决war包发布时报:java.lang.ClassCastException:org.apache.catalina.util.DefaultAnnotationProcessor cannot b
- C语言: 几个测试题
- VS里各种链接相关问题和解决方法
- ora-01940处理(杀session解锁)
- mahout seq2sparse源文件解析
- __declspec(dllexport) & __declspec(dllimport)
- SQL Server 数据库迁移孤立用户的解决方法
- C++ - Adapter模式
- 使用路径变形编辑器制作坦克履带动画
- UTI 唯一类型标识
- ArcGIS Server Java ADF案例教程
- Flex的RSL部署