SELECT * FROM gv$lock WHERE type in ('TX','TM') AND request>0 order by type,ctime;