session4.sql

set pagesize 9999
column sid noprint
column sess_id format a16;
column username format a20;
column program format a24;
column osuser format a12;

SELECT sid
	, sid || ',' || serial# sess_id
	, username
	, program
	, osuser
FROM v$session
ORDER BY 1
/