SELECT * FROM gv$lock WHERE type in ('TX','TM') AND lmode > 0 and id1 like '%&1%' order by type,ctime desc;