Ever heard of problems with dead/hanging Oracle user processes?
I'll bet that there isn't a single person out there that developes software that interacts with an Oracle
database that hasn't come across the situation where his/hers application has gone berserk
and started hundreds of users sessions/processes.
Basically when you've come to the point when you need to clean up the processes you got two straightforward solutions.
1) reboot the database instance
2) start killing the sessions one by one
The first solution is less that optimal and the second is a rather boring and tedious job.
So here's the solution.
A simple application that allows you to log onto an Oracle database and view/kill any of the available sessions.
General Features
Aside from the obvious feature of killing sessions the tool also allows you to
save the session information, i.e. host, SID, etc for future usage.
In order for the application to be able to connect to an database instance
some information is required:
Host - The hostname/IP-address of the server
SID - The service id of the instance
Port - The listener port on the server (default 1521)
User - The user name for a system user or equivalent
Password - The password for the above user
When you've supplied the required information you can click on the button just to the right
of the drop down box to add the info to the drop down list.
The button with the trashcan icon will remove an item from the drop down list.
Kicking sessions
Once you're logged onto the database the tool is fairly obvious.
Just choose what/which sessions to kill and click on the "kill" button.
The other button reloads the list of available sessions.
None so far.
