Hi,
Oracle 11gDB
I have this suspiscious process in my v$session that is always running and connected to a schema "HR", even if the The "HR" application is also stopped and other Batch HR related process.
And it tells me also that it came from the unix machine sun-server1. My problem is I can not locate the OS PPID for this process when i login to OS at sun-server1.
I tried killing this session but it keeps on connecting. Even if I bounce back the database, it keep on coming back.
How to I find the source of this process at the sun-server1?
I tried this script:
SELECT p.program, p.spid
FROM v$session s, v$process p
WHERE s.paddr = p.addr
AND s.sid IN (39)
Program Spid
============ ====
ORACLE.EXE (SHAD) 6404
But if I ps -ef |grep 6404 there is no OS process existing. Any other script that can list the OS process id?
Thanks a lot,