Hello everyone,
we sometimes have Problems with some 12.1.0.2 Databases on Windows Server 2016 where are some "dead processes" left which aren't connected to a session:
SELECT spid FROM v$process WHERE addr NOT IN (SELECT paddr FROM v$session) AND PROGRAM = 'ORACLE.EXE (SHAD)';
Sometime they disappear on them own and I can kill them if there are too many, but I would like to find the cause of it. Has someone a hint how I can do that?
Thanks beforehands,
Markus