Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cause of Processes without Sessions

User_EV0K7Dec 12 2019 — edited Jan 8 2020

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

Added on Dec 12 2019

#general-database-discussions

5 comments

822 views