Abnormally disconnected oracle users are not disconnected from database !
Dear Friends ,
We are using Oracle Database 10g (10.2.0.1.0) in AIX 5.3 server . We have 300+ oracle user who are connected in the database via a .net application . Here all application user are the oracle user here .
Recently I got a problem . When a user connects to my database and disconnect abnormally (i.e. , not exit properly specially for power failure) then that user session does not disconnected from the database . session remains on the v$session.
And when that user again connect to my database again then the user connects again with a different user's SID . And the old user session still remains on the database . In this momnet I got two sessions with same username at a time with different SID and both their status are INACTIVE. In this moment , I need to kill the old user session . But it is very hassle to me . I understand that it is error of our application .
Now anybody plz tell me , is there any oracle related parameter which find out the abnormally disconnected user and make disconnected automatically . I have to try using "sqlnet.expire_time=5" parameter but not success .
Can anybody plz help me regarding this issue ?
Edited by: shipon_97 on Mar 12, 2009 5:35 PM