select s.sql_text,USERNAME,OSUSER,MACHINE,TERMINAL,PROCESS,PROGRAM,LOGON_TIME
from v$session a, v$sqlarea s
where a.sql_address = s.address(+)
and a.sql_hash_value = s.hash_value(+)
order by logon_time desc;
from v$session a, v$sqlarea s
where a.sql_address = s.address(+)
and a.sql_hash_value = s.hash_value(+)
order by logon_time desc;