-- Session infos
select username,status,osuser,machine,program
from v$session where username like '%user%';

-- Anzahl der Logswitches
select Switches "Anzahl Switches",
to_date(Datum,'DD.MM.YY') Datum
from
(select count(*) Switches,
to_char(first_time, 'DD.MM.YY') Datum
from v$loghist
group by to_char(first_time, 'DD.MM.YY'))
order by to_date(Datum,'DD.MM.YY');

-- Session mit den meisten Änderungen (Archivelogs)
SELECT s.sid, s.serial#, s.username,
s.program, i.block_changes
FROM v$session s, v$sess_io i
WHERE s.sid = i.sid 
and program !='ORACLE.EXE' ORDER BY 5 desc, 1, 2, 3, 4;