Detecting Orphan SQLnet Shadow Processes

From: Lee E Parsons <lparsons_at_world.std.com>
Date: Mon, 4 Apr 1994 19:50:05 GMT
Message-ID: <Cnr33I.AAM_at_world.std.com>


Given a large Database Server with many Shadow Tasks (100+) attaching from PC clients, how do you identify and kill idle processes associated with rebooted/down PC's?

A user could lock a number of important files then shutdown his system. The shadow task would not go away but when asked the user would not think he was still accessing the system.

Certainly this problem could be tracked down via the lock monitors but that seems very manual and timeconsuming for a large shop.

How do people routinely avoid/clean up this type of problem?

Additionally, we find this senario is a problem when shutting down the system. ie) Are the remaining processes orphan shadow tasks or just users who have not gotten the word to log off?

-- 
Regards, 

Lee E. Parsons                  		
Systems Oracle DBA	 			lparsons_at_world.std.com
Received on Mon Apr 04 1994 - 21:50:05 CEST

Original text of this message