REM
REM **********************************************************************
REM Filename:	ora_sessions.sql
REM Author:	Darryl Smith - Active Database Solutions, Inc.
REM Date:	7/31/97
REM
REM Description:
REM   This script displays all oracle user sessions.
REM
REM Comments:
REM 
REM **********************************************************************
REM
ttitle center 'Session Monitor' skip 2
column who format a10 heading "Oracle|Username"
column oswho format a10 heading "O/S|Username"
column server format a9 heading "SQLNET|Server"
column status format a8 heading "Status"
column sid format 999 heading "Sess|SID"
column user# format 999 heading "Ora|ID"
column process format a4 heading "O/S|PID" 
column terminal format a8 heading "Terminal"
column serial# format 9999999 heading "Serial|Killer#"
set linesize 132
select server,status,sid,serial#,user#,substr(process,5,4) 
       process,terminal,
       substr(username,1,15) who,
       substr(osuser,1,8) oswho,
       substr(machine,1,7) "Machine",
       substr(program,1,45) "Software"
from v$session where type = 'USER'
order by oswho;