Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Active sessions after powerfailer network components

Active sessions after powerfailer network components

From: belgarion1 <bel.garion_at_hccnet.nl>
Date: Tue, 18 Apr 2006 12:47:28 +0200
Message-ID: <seg942l2rh1rorupldl83m1cmthog9j0fo@4ax.com> 





Hi,



Recently we have had a lot of active sessions after a powerfailer of
network components.


To solve this, i know of these optins :


kill all "hanging sessions"  ( time consuming and you have to stop the
listener so no one can logon )


do a shutdown of the database



Are there any other options and can anyone tell what the best option
is in case of massive hanging sessions



Thanks in advance



The Oracle version is 9.2.0 on a AIX platform.
Received on Tue Apr 18 2006 - 05:47:28 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US