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…
This is something I have been wanting for a while. I need a way to quickly show SQL Statement performance over time for 1 statement, especially to identify Execution Plan volatility. When researching performance problems I often need to quickly digest historical performance of a…
This is my v2 of a presentation on ideas for going beyond the Application Express default graphs and info on 3 popular Javascript graphing libraries that can be incorporated into Apex Applications. 2013-06-DavidMann-ExploreNewDataDimensionsWithApexAndFOSSGraphingLibraries.pdf The visualization space is growing daily so I expect things to evolve,…
Due to some unforeseen circumstances I was unable to spend as much time as I would have liked at KScope13 in New Orleans but boy did I pack a lot into the 24 hours that I was there. First of all I want to thank…
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…