select sid, serial#, substrb(username,1,10), status, terminal, osuser,
to_char(logon_time,'yymmddhhmiss'),program,lockwait
from v$session
where substrb(username,1,8) = 'APROJECT'
and STATUS ='ACTIVE'
order by logon_time