select /*+rule*/ decode(request,0,'holder:','waiter:') holder,sid,id1,id2,lmode,request,type,ctime,block from v$lock