library cache lock holding session

有个分区表800G，给他添加一个字段：

 

alter table ODS_HTTP_ACCESS_LOG add GPRS_GATEWAY varchar2(50) default '';

 

 

添加后，再开另外一个session B：

 

insert into statuser. ODS_HTTP_ACCESS_LOG select * from statuser. ODS_HTTP_ACCESS_LOG  where rownum<2;

 

 

用sql，检查哪个session holding session：

 

SQL> SELECT s.sid, kglpnmod "Mode", kglpnreq "Req", SPID "OS Process"
  2  FROM v$session_wait w, x$kglpn p, v$session s ,v$process o
  3  WHERE p.kglpnuse=s.saddr
  4  AND kglpnhdl=w.p1raw
  5  and w.event like '%library cache%'
  6  and s.paddr=o.addr
  7  /

       SID       Mode        Req OS Process
---------- ---------- ---------- ------------
       322          3          0 17200
       322          3          0 17200

 

 

SQL> select sid,p1raw from v$session_wait where event='library cache lock';

       SID P1RAW
---------- ----------------
       305 000000014DBF0C00

 

 

SQL> SELECT kglnaown "Owner", kglnaobj "Object"
  2      FROM x$kglob
  3     WHERE kglhdadr='000000014DBF0C00';

Owner
----------------------------------------------------------------
Object
--------------------------------------------------------------------------------
STATUSER
ODS_HTTP_ACCESS_LOG