Operation System Version Oracle Version
Windows Server 2003 10.2.0.3
We didn’t find any clue in the alert log and we are unable to kill the shadow process session at os level.
SQL>Select DISTINCT SPID,Program from V$process;
1173 rows selected
SQL>Host taskkill /pid 8880 /pid 2234
Processes with Pid 8880 and 2234 are not existed.
Kindly help us to avoid this.
Many Thanks in advance,
Bharat Kumar| Hyderabad | India
I don't run Oracle on Windows very often, so I'm not the best person to comment on this...
The shadow processes are a normal part of Oracle connections. When a person creates a new dedicated connection a shadow process is spawned to handle that connection. When they disconnect, the shadow process should die. You need to check if you are having problems with Dead Connection Detection (DCD), which is a problem on some versions of Oracle on Windows. There are a number of MOS notes on this, including this one.
https://support.oracle.com/epmos/faces/ ... d=395538.1
If you have extremely large numbers of users, you should probably consider using Shared Server (formally know as Multi Threaded Server) for your connections, rather than dedicated connections.
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 1 guest