select
        s.SID,
        p.spid,
        piece,
        s.status,
	to_char(s.logon_time,'DD/MM/YYYY HH24:Mi:SS') QUANDO,
        c.sql_text
from
        gv$session s,
        gv$process p,
        gV$sqltext c
where   c.address = s.sql_address
  and   s.paddr = p.addr(+)
group by s.sid,p.spid,piece,s.status,s.logon_time,c.sql_text
order by s.sid, piece;