Re: Killed database sessions

From: Dana Stockler <stockler_at_ingdata.no>
Date: 1997/03/05
Message-ID: <01bc29a5$d039e8d0$27658fc2@dana_home_pc>#1/1

| Indeed PMON is the culprit here. It is supposed to clean up killed
| sessions as well as monitor things like inactive sessions that exceed
| idle time settings or elapsed time settings. However because of the
| performance hit Oracle does not have PMON monitor processes constantly
| and it is unclear how often it is actually activated to remove these
| killed sessions. The manual says minutes but I have experienced killed
| sessions still showing in V$SESSION for hours or days. I agree this is
| frustrating. Since I am not a 7X24 shop I can do a shutdown abort to kill

| the sessions, but I feel for those who are. I too would be interested to
| hear if there is another solution!!!

Sounds like a swift kick in the butt at regular intervals would do wonders for PMON's attitude.

-
Dana Received on Wed Mar 05 1997 - 00:00:00 CST