column username format a10

select s.username, l.* from
(SELECT
        l.sid,
        l.type,
        l.id1,
        l.id2 ,
        l.lmode,
        l.request,
        l.CTIME
FROM
        v$lock l
WHERE
        l.type in ('TX', 'TM') ) l,
        v$session s
where
       l.sid = s.sid
/