marți, 5 aprilie 2016

SQL Developer see/check/kill sessions

If you want to check/kill opened sessions with the database, you can follow the steps below (your user must be DBA):
1. In SQL Developer go to View -> Reports. This will show you the window with the reports.
2. In the Reports window go to Data Dictionary Reports -> Database Administration -> Sessions -> Sessions . Here you can see informations about each session. If you need to kill a session you have to select a field of the row you want to delete then right click -> Kill Session

Niciun comentariu:

Trimiteți un comentariu