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 sessions with no programs run it

kareemAug 16 2010 — edited Aug 16 2010

hi all,
my database is 10gR2 with developer 6i
the database have huge number of sessions with no programs running it like oracle form, some of those sessions stack in v$session table due to power failure.
restart server solve the problem, but it is not efficient.
is there any method to fined witch of database sessions is actually connect to the database and have application running it ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 13 2010

Added on Aug 16 2010

#general-database-discussions

8 comments

2,434 views