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