Check os process id of your session from sql prompt.
select p.spid, s.username, s.status, s.server, to_char(s.logon_time,'DD-MON-YY HH24:MI') from v$process p, v$session s where p.addr = s.paddr and s.status='ACTIVE';
SPID USERNAME STATUS SERVER ------------------------ ------------------------------ -------- --------- TO_CHAR(S.LOGON_TIME,'DD-MON-YYHH24:MI') --------------------------------------------------------------------------- 18658 TEST1 ACTIVE DEDICATED 08-JAN-18 15:07 18664 TEST1 ACTIVE DEDICATED 08-JAN-18 15:07 23691 TEST1 ACTIVE DEDICATED 08-JAN-18 15:15 SPID USERNAME STATUS SERVER ------------------------ ------------------------------ -------- --------- TO_CHAR(S.LOGON_TIME,'DD-MON-YYHH24:MI') --------------------------------------------------------------------------- 14794 SYS ACTIVE DEDICATED 08-JAN-18 15:03 73 rows selected.
My session
[oracle@actx3650m501 ~]$ ps -ef| grep mdc oracle 2761 1 1 14:48 ? 00:00:17 oraclemdc (LOCAL=NO) oracle 2783 1 0 Jan06 ? 00:00:06 oraclemdc (LOCAL=NO) oracle 5985 1 0 Jan04 ? 00:00:11 ora_w009_mdc oracle 7522 1 0 2017 ? 00:01:10 ora_w002_mdc oracle 8010 1 0 14:55 ? 00:00:00 oraclemdc (LOCAL=NO) oracle 9307 1 0 Jan06 ? 00:00:05 ora_w000_mdc oracle 10128 1 0 14:58 ? 00:00:00 ora_j000_mdc oracle 12332 1 0 15:00 ? 00:00:06 oraclemdc (LOCAL=NO) oracle 14266 1 0 Jan04 ? 00:00:14 ora_w00d_mdc oracle 14303 1 0 Jan06 ? 00:00:04 ora_w00b_mdc oracle 14794 14793 0 15:03 ? 00:00:00 oraclemdc (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) oracle 15429 1 0 2017 ? 00:03:45 ora_pmon_mdc oracle 15431 1 0 2017 ? 00:06:21 ora_psp0_mdc
