Query
Karthik, May 03, 2017 - 10:06 am UTC
get the process id from top command at unix/linux
pass the process id in the below sql:
SELECT s.client_identifier,s.action,s.status,s.module,s.osuser,s.machine,s.terminal,s.program, s.* FROM v$session s, v$process v WHERE v.addr=s.paddr AND v.spid=&spid;
Thanks
Karthik Rao