DBA Data[Home] [Help]

VIEW: SYS.DBA_KGLLOCK

Source

View Text - Preformatted

select kgllkuse, kgllkhdl, kgllkmod, kgllkreq, 'Lock' kgllktype from x$kgllk
 union all
  select kglpnuse, kglpnhdl, kglpnmod, kglpnreq, 'Pin'  kgllktype from x$kglpn
View Text - HTML Formatted

SELECT KGLLKUSE
, KGLLKHDL
, KGLLKMOD
, KGLLKREQ
, 'LOCK' KGLLKTYPE
FROM X$KGLLK UNION ALL SELECT KGLPNUSE
, KGLPNHDL
, KGLPNMOD
, KGLPNREQ
, 'PIN' KGLLKTYPE
FROM X$KGLPN