I want to unlock the locks obtained on a table. I tried killing the session but i dont have the dba privilege. Is there any way to do it? Executing COMMIT or ROLLBACK afterward didn't help, because since I started Oracle SQL Developer I got a new session ID. After a while Oracle removed the inactive sessions and locks, but I would like to have a way to remove the locks as a non-admin user


There is no way for non-dba sessions to kill other sessions, or interfere with their locks in any way. Think about it. That would be a security disaster.

You need to issue your commit or rollback in the same session that launched the query. If you lose the session, you must ask your DBA to kill it for you.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.