col module for a35
col machine for a15
col username for a10
col holder for a10
col final for a10
col sql_id...for a15
col exec_gets for 99999999
col seconds for a5
col object_id for 999999
col param for a30
col sql_text...mi:ss';
select a.sid,
a.username,
a.machine,
a.module,
a.event,
a.sql_id...,0,6) sql_text
from v$session a, v$process b,v$sql c
where a.paddr = b.addr(+)
and a.status = '...=c.sql_id(+)
and a.sql_child_number=c.CHILD_NUMBER(+)
and b.spid='&SPID'
order by a.sql_id, a.machine