break on sid skip 1
set linesize 300
set pagesize 999
column sid format 99999
column sql_text format a100
column machine format a20
column username format a10
column client_info format a15
select a.sid, a.serial#,a.username,a.machine,a.last_call_et ,to_char(logon_time,'yy-mm-dd:hh24:mi'),client_info,b.sql_text
from v$session a,v$sqltext b
where a.username is not null
and a.status = 'ACTIVE'
and a.sql_address = b.address and a.username<>'SYSTEM'
order by a.last_call_et,a.sid,b.piece;
|