Oracle shadow process Oracle.exe(SHAD) process increasing

General suggestions and comments about the forums.

Moderator: Tim...

Posts: 1
Joined: Thu Sep 12, 2013 2:01 pm

Oracle shadow process Oracle.exe(SHAD) process increasing

Postby bharat.gundubilli » Thu Sep 12, 2013 2:08 pm

In my test database Oracle Shadow Process (Oracle.exe (SHAD)) increases exponentially due to this we are getting max Process reached hence we are unable to connect database remotely.

Operation System Version Oracle Version
Windows Server 2003

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;
8880 Oracle.exe(SHAD)
2234 Oracle.exe(SHAD
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

Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Oracle shadow process Oracle.exe(SHAD) process increasin

Postby Tim... » Fri Sep 13, 2013 6:57 am


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. ... 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
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website:
My blog:

Return to “Suggestions and Comments”

Who is online

Users browsing this forum: No registered users and 1 guest