ORA-03170有没有临时解决的方法
2016-03-19 · 百度知道合伙人官方认证企业
育知同创教育
1【专注：Python+人工智能|Java大数据|HTML5培训】 2【免费提供名师直播课堂、公开课及视频教程】 3【地址：北京市昌平区三旗百汇物美大卖场2层，微信公众号：yuzhitc】
向TA提问
关注
![]()
展开全部
打补丁
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 6 11:53:09 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ ONLY WITH APPLY
复制代码
SQL> select sid,serial#,status from v$session where sid=3480;
SID SERIAL# STATUS
---------- ---------- --------
3480 34491 ACTIVE
复制代码
SQL> select c.spid from v$process c where c.addr = (select b.paddr from v$session b where b.sid = '3480');
SPID
------------------------
135347
复制代码
ps -ef|grep 135347
oracle 15602 79971 0 12:00 pts/1 00:00:00 grep 135347
会话是不存在的
复制代码
SQL> select sid,serial#,status from v$session where sid=3480;
SID SERIAL# STATUS
---------- ---------- --------
3480 34505 ACTIVE
SQL> alter system kill session '3480,34505';
alter system kill session '3480,34505'
*
ERROR at line 1:
ORA-00030: User session ID does not exist.
SQL> select sid,serial#,status from v$session where sid=3480;
SID SERIAL# STATUS
---------- ---------- --------
3480 34507 ACTIVE
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 6 11:53:09 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ ONLY WITH APPLY
复制代码
SQL> select sid,serial#,status from v$session where sid=3480;
SID SERIAL# STATUS
---------- ---------- --------
3480 34491 ACTIVE
复制代码
SQL> select c.spid from v$process c where c.addr = (select b.paddr from v$session b where b.sid = '3480');
SPID
------------------------
135347
复制代码
ps -ef|grep 135347
oracle 15602 79971 0 12:00 pts/1 00:00:00 grep 135347
会话是不存在的
复制代码
SQL> select sid,serial#,status from v$session where sid=3480;
SID SERIAL# STATUS
---------- ---------- --------
3480 34505 ACTIVE
SQL> alter system kill session '3480,34505';
alter system kill session '3480,34505'
*
ERROR at line 1:
ORA-00030: User session ID does not exist.
SQL> select sid,serial#,status from v$session where sid=3480;
SID SERIAL# STATUS
---------- ---------- --------
3480 34507 ACTIVE
本回答被提问者采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
