Manage/kill sessions in Oracle

A connection is a network link connection to the database. A connection can have 0, one or many sessions, but the normal situation is only one session per connection.
The tasks in a session are executed by processes. But a process does not have to be dedicated to a specific session.

If you want to see the current active sessions, select the v$session table:
Continue reading