SQL Developer Kill Session

In this post, we'll talk about how to monitor sessions and kill sessions in SQL developer.

Monitor Sessions

To monitor sessions in SQL developer, you may find the entry in the function menu of "Tools".

SQL Developer - Tools - Monitor Sessions

Select Connection

Then select which database you want to connect to and monitor.

SQL Developer - Choose Connection

SQL Developer Kill Session

Right-clicking on any one of sessions shows a menu, there're more actions you can do on it, which include killing the session.

SQL Developer - Kill Session

SQL Developer Reports

There're more various session monitoring in "Reports" panel. The navigation path is as below:

SQL Developer - More Session Monitoring

You may take a look.

Next, let's talk about how to use SQL Developer to monitor top SQL statements.