From: erenner932@aol.com (ERenner932)
Subject: Re: Killed database sessions
Date: 1997/03/03
Message-ID: <19970303204500.PAA28865@ladder02.news.aol.com>#1/1
References: <01bc2259$99bf5c20$542b7dc1@dabr>
Organization: AOL http://www.aol.com
Newsgroups: comp.databases.oracle.server
X-Admin: news@aol.com



Alex,

If anyone knows to the contrary it would be very interesting, as I am
suffering from the same issue.
Apparently, a kill session is very low on the priority stack in relation
to PMON who cleans out the sessions (I think its PMON).  But on a very
busy system it could take HOURS to clean out, as it is processing other
requests with higher priority.
I think this is a serious issue and should be addressed by Oracle.  How
can you expect to meet customer needs as well as system needs when you
can't implement Profiles without running into these issues?
Very frustrating.
Hope this is helpful and someone else can correct/support/help on this
comment.
Ernst Renner

erenner@thehartford.com