ThatJeffSmith

Tag: kill

Die! Or How to Cancel Queries in Oracle SQL Developer

I’m not sure why, but it appears many of you wish you could take back your SQL queries. It’s like that one time you posted that picture on Facebook and immediately (3 days later) you realized it wasn’t a great career move. Maybe that data you asked for wasn’t going to be that helpful if [...]

Locks and Killing Sessions in Oracle SQL Developer

Getting the Windows ‘busy’ hourglass cursor is sure to raise anyone’s blood pressure. Sometimes you’re left there waiting because a resource you’re attempting to access is already being used by someone else. So you get to WAIT. You are being BLOCKED because what you want is LOCKED. How can you see what the hold-up is? [...]