ORACLE. Información session del usuario

-- información usuarios

select v.sid, v.serial#, v.username, v.program
from user_users u, v$session v
where v.user# = u.user_id 

select *
from user_users u, v$session v
where v.user# = u.user_id 

-- session del usuario

select userenv('sessionid')
from dual; 

--- información del usuario apartir de la session
select *
from user_users u, v$session v
where v.user# = u.user_id
and audsid = userenv('sessionid')

select *
from user_users u, v$session v
where v.user# = u.user_id
order by LOGON_TIME DESC 

select SCHEMANAME, OSUSER, MACHINE, TERMINAL, PROGRAM, MODULE, LOGON_TIME
from user_users u, v$session v
where v.user# = u.user_id
order by LOGON_TIME DESC