Oracle redo logs

Checkpoint not complete: Comment limiter les alertes liées à la journalisation

select THREAD#, SEQUENCE#, FIRST_CHANGE#, to_char(FIRST_TIME, 'DD-MON-YYYY HH24:MI:SS') first_time, SWITCH_CHANGE# from v$loghist;

Liste session

set pages 1000
set lines 1000

select USERNAME, OSUSER, MACHINE, PROGRAM from v$session;
ou

select distinct username from v$session;
select USERNAME, OSUSER, MACHINE, PROGRAM from v$session where username in ('xxx', 'yyy');

En rac oracle :
select USERNAME, OSUSER, MACHINE, PROGRAM from gv$session;