Á¢¼ÓµÈ user È®ÀÎ Äõ¸®
ÀÛ¼ºÀÚ °ü¸®ÀÚ ÀÛ¼º½Ã°£ 2009-01-08 15:56:18
 

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


¸ñ·Ï | ÀÔ·Â | ¼öÁ¤ | ´äº¯ | »èÁ¦