ThatJeffSmith

Tag: kill

How To Add Custom Actions To Your User Reports

I’ve shown you and more than a few customers how to customize your Monitor Sessions page/report. If you need a refresher, that’s here. But basically it comes down to this: Copy the report from the Database Administration section of the Reports panel Paste it to the User Defined Reports section Edit to your heart’s delight […]

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? […]