Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to kill a query in SQL Developer without admin privilages

mohansFeb 20 2020 — edited Feb 21 2020

Hi, I am using SQL Developer vers 19.1.0.094 Build 094.2042 on a work computer. It means I don't have admin privilages.

My quest is how its possible for me to kill a sql session. Because, sometimes the query goes on for ever. I tried to use the Monitor Sessions but I got this error message.

pastedImage_3.png

I thought may be installing Oracle Instant Client my solve my problem, but I don't konw how to configure it after the installation; what is the Client Location I should choose and so on.

pastedImage_7.png

Any suggestions or links will be appreciated

Comments
Post Details
Added on Feb 20 2020
4 comments
1,457 views