› Fóruns › Banco de dados Oracle › Tabelas com varios usuarios › Tabelas com varios usuarios
8 de junho de 2009 às 4:04 pm
#87202
Rodrigo MesquitaParticipante
Romulo, utilize esse select.
SELECT LPAD(‘ ‘, (level-1)*2, ‘ ‘) || NVL(s.username, ‘(oracle)’) AS username,
s.osuser,
s.sid,
s.serial#,
s.lockwait,
s.status,
s.module,
s.machine,
s.program,
TO_CHAR(s.logon_Time,’DD-MON-YYYY HH24:MI:SS’) AS logon_time
FROM v$session s
CONNECT BY PRIOR s.sid = s.blocking_session
START WITH s.blocking_session IS NULL;