SQL> select sid,serial#,paddr,program,username,to_char(logon_time,'yyyy-mm-dd hh24:mi:ss') from v$session where username='YDNC' order by logon_time;
SID SERIAL# PADDR PROGRAM USERNAME TO_CHAR(LOGON_TIME,'YYYY-MM-DD
---------- ---------- -------- -------------------- ------------------------------ ------------------------------
1 316 7B80AC78 YDNC 2013-12-14 12:58:30
42 11 7B80CA28 YDNC 2013-12-14 12:58:30
3 775 7B80B858 YDNC 2013-12-14 12:58:30
5 59 7B80D018 YDNC 2013-12-14 12:58:30
6 419 7B809AA8 YDNC 2013-12-14 12:58:30
7 45904 7B80DBF8 YDNC 2013-12-14 12:58:30
8 23528 7B80D608 YDNC 2013-12-14 12:58:30
10 235 7B807118 YDNC 2013-12-14 12:58:30
20 8 7B8088D8 YDNC 2013-12-14 12:58:30
21 8 7B806538 YDNC 2013-12-14 12:58:30
22 8 7B8094B8 YDNC 2013-12-14 12:58:30
23 8 7B806B28 YDNC 2013-12-14 12:58:30
24 7 7B805958 YDNC 2013-12-14 12:58:30
25 8 7B807708 YDNC 2013-12-14 12:58:30
26 8 7B80C438 YDNC 2013-12-14 12:58:30
31 17815 7B80E1E8 YDNC 2013-12-14 12:58:30
37 27964 7B80A688 YDNC 2013-12-14 12:58:30
38 10 7B807CF8 YDNC 2013-12-14 12:58:30
39 10 7B8082E8 YDNC 2013-12-14 12:58:30
2 61617 7B80A098 YDNC 2013-12-14 12:58:30
20 rows selected