Session kill does not work

[ed10k]

After a select the first page of results is there.

I want to logoff this session to free Database resources. BUT: Session -> Kill is grayed out.
I believe that this is because this connection does not have DBA-Role or access to v$-views.

However this should be doable without DBA-rigths as well.

 

[Marco Kalter]

The Session > Kill menu item does indeed require the ALTER SYSTEM privilege to execute the kill session statement. There is no function to explicitly log off the session of a specific window.

 

[ed10k]

Can you alter that?

If the session is active then "alter system kill session ..".
If then session is not active then simply logoff.

 

[Marco Kalter]

I have added this to the list of enhancement requests.