set pages 300 set lines 200 col username for a10 col machine for a10 col program for a30 select inst_id, sid, serial#, username, status, machine, program, last_call_et from gv$session where username='SYSTEM' order by 1,6;