Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Kill INACTIVE state sessions

562832May 29 2007 — edited Nov 7 2007

Hi all,

In my Database (v 9.2.0.4) ,all sessions which are connected by Application server ( oracle 10g R 1) are inactive even after user's are sign-off. And in Application server Data sources they set inactivity_timeout=30 (sec).

Now we are manually kill those session and also there is an entry in v$sessions.

Can any one help how to kill these sessions ( i know kill -9 pid), but find out those unix process is difficult to me. Please help me any one

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 5 2007

Added on May 29 2007

#general-database-discussions

14 comments

4,167 views