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 EASY_BANK ACTIVE DEDICATED
08-JAN-18 15:07

18664 EASY_BANK ACTIVE DEDICATED
08-JAN-18 15:07

23691 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

 

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.