WRH$_SQL_PLAN 被锁
SYS@ hanmi> r
1 SELECT /*+ rule*/
2 a.sid, b.owner, object_name, object_type
3 FROM v$lock a, all_objects b
4 WHERE TYPE = 'TM'
5* and a.id1 = b.object_id
SID OWNER OBJECT_NAME OBJECT_TYPE
---------- -------------------- ------------------------------ -------------------
451 SYS WRH$_SQL_PLAN TABLE
451 SYS WRH$_SQL_BIND_METADATA TABLE
SYS@ hanmi> select sid,serial#,username from v$session where sid=451;
SID SERIAL# USERNAME
---------- ---------- ------------------------------
451 10567
SYS@ hanmi> select a.username, a.sid,b.SQL_TEXT, b.SQL_FULLTEXT
2 from v$session a, v$sqlarea b
3 where a.sql_address = b.address AND SID=451;
no rows selected
SYS@ hanmi>
1 SELECT /*+ rule*/
2 a.sid, b.owner, object_name, object_type
3 FROM v$lock a, all_objects b
4 WHERE TYPE = 'TM'
5* and a.id1 = b.object_id
SID OWNER OBJECT_NAME OBJECT_TYPE
---------- -------------------- ------------------------------ -------------------
451 SYS WRH$_SQL_PLAN TABLE
451 SYS WRH$_SQL_BIND_METADATA TABLE
SYS@ hanmi> select sid,serial#,username from v$session where sid=451;
SID SERIAL# USERNAME
---------- ---------- ------------------------------
451 10567
SYS@ hanmi> select a.username, a.sid,b.SQL_TEXT, b.SQL_FULLTEXT
2 from v$session a, v$sqlarea b
3 where a.sql_address = b.address AND SID=451;
no rows selected
SYS@ hanmi>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/27036311/viewspace-1089143/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- Docker启动失败：Failed to start Docker Application Container Engine 解决办法
- MySQL配置文件
- 如履薄冰
- Windows 批处理之DATE命令的使用方法
- nginx 常见参数以及重定向参数配置
- Oracle 低版本客户端连接 18c 报ORA-28040 和 ORA-01017 错误的解决方法
- Linux(CentOS)下安装Redis(redis-4.0.1)
- “穷清华，富北大不要命的中科大”究竟是什么意思
- CentOS7.1安装Oracle 12.1客户端以及cx_Oracle
- 深度分析Linux下双网卡绑定七种模式 多网卡的7种bond模式原理
