I'm a fan of SQL Developer, have been for years. I especially like User Defined Reports. It looks like SQL Developer is moving away from the current Java Standalone App towards a Microsoft VS Code Plugin model. Jeff Smith has a Blog Post from Jan…
I've gotten a lot of mileage out of my old SQL Developer Archive Log Count Heat Map report that I created in SQL Developer. I was recently asked to estimate the amount of redo that might be sent to a DataGuard standby. Searching The Google…
This second vizualization is more of a workflow proof of concept compared to some novel visualization but I can guarantee you haven't seen the SCOTT.EMP table like this before. I have wanted to combine my two favorite tools for a while. Here is how you…
I enjoyed giving my presentation on SQL Developer User Defined Reports to the 2014 East Coast Oracle Users Conference. This is a local conference that is a great value and pulls in lots of fun folks that attend and present. DMann-SQLDeveloper4Reporting.pdf Check out my GitHub…
During my preparation for a visualization presentation at East Coast Oracle Users Group I realized I had an opportunity for a teaching moment on Levels of Abstraction. A few months back I published my PL/SQL code for an Archived Log Switch Heat Map. Below is…
I added a page to my SQL Developer Tips and Tricks page about integrating the Google Graph API with SQL Developer HTML reports. I sometimes run out of steam with the built in chart and gauge capabilities of SQL Developer. With a little work you…
... or just use SQLPLUS to spool to HTML and open with a browser if you are old school :) I am on week 4 of my newly reimaged work laptop sans Toad. I am trying to make a go of things with SQL Developer…
If you are using SQL Developer 2.x you can reduce your startup time by about 20% by disabling any unneeded extensions. I was able to reduce my startup time from 11 seconds to 8 seconds by turning off all extensions (none of which I really…
When trying to debug for another user sometimes it is helpful to be able to log in as that user. In the past magic was done by admins by storing the encrypted passwords, setting to a new temporary password, logging in, and then resetting the…
I added a new tutorial to my collection of SQL Developer information. The tutorial covers creation of a HTML Custom Report for SQL Developer. Here is an example of the report running and showing 1 long operation (click to enlarge): If you would like to…