Oracle-L: defunct processes after patch application on Compaq Tru64 Unix

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Mon, 26 May 2003 09:26:32 -0800
Message-ID: <F001.005A29AD.20030526092632@fatcity.com>

After Applying patch Kit "4" of Compaq Tru64 Unix 5.1A , about 200 concurrent defunct PIDs are spawning during a peak concurrent user load of 800 concurrent application users .

"defunct" process is generated :-
1) when doing an ordinary telnet unix login to the machine

2) when doing sqlplus <user>/passwd@<connect string> to the database server NOTE - NO defunct process is generated when doing direct sqlplus call to database

3) when doing application login which spawns a database connecttion thru SQL*Net NOTE - The defunct PID Values belonging to a unix user keep Changing . Seemingly NEW defunct processes keep getting spawned as old ones die off

This is causing a severe Application performance degradation on production even though there is plenty of FREE CPU & memory available

NOTE -
1) Before application of patch kit "4" , FEWER defunct processes ( 50 at max. ) used to exist at any point in time

2) Each application user spawns approx 4 unix processes while working with the application

3) Network thruput is OK between Application & Database Server

Qs. Is spawning of defunct processes during unix login normal ?
Qs. anybody has applied Patch kit "4" on Tru64 Unix ?
Qs. Any ideas how this issue may be approached ?

Thanks

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infosys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon May 26 2003 - 12:26:32 CDT