How To Add Custom Actions To Your User Reports

thatjeffsmith SQL Developer 13 Comments

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 But. Some of you have …

Locks and Killing Sessions in Oracle SQL Developer

thatjeffsmith SQL Developer 18 Comments

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? And more importantly, how can …