set linesize 200 set pagesize 32000 column sid format a10 column username format a10 column terminal format a10 column sql_text format a40 wrap Select ''''||s.sid||','||s.serial#||'''' SID ,s.status ,s.username ,s.terminal ,q.SQL_TEXT ,q.command_type from v$session s ,(select distinct address ,sql_text ,command_type from v$sql) q where q.address=s.sql_address order by s.sid /