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>