set echo off
set feed off
set linesize 512

prompt ------------------------------------------
prompt - Liste des sessions actives de la base --
prompt ------------------------------------------

column machine format a30
column osuser format a30
column module format a20

SELECT 
   machine, 
   process, 
   osuser, 
   username,
   schemaname, 
   status, 
   lockwait, 
   sid,
   serial#, 
   module, 
   action
FROM 
   v$session
WHERE 
   username is not null
AND 
   osuser is not null
ORDER BY 
   machine, 
   osuser, 
   username,
   schemaname, 
   status, 
   module;
