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>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27036311/viewspace-1089143/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27036311/viewspace-1089143/