Submitted by dmann on Wed, 08/06/2014 - 00:58
The first visualization I will be working on 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 Execution Plan volatility. When researching performance problems I often need to quickly digest historical performance of a trouble statement.
Luckily Oracle 10g/11g/12g have this type of information in the Active Workload Repository.
Unluckily I have usually just seen this presented in tabular format with no easy way to gain some context. Read more about August - Visualization 1 - SQL Execution Plan Volatility
Submitted by dmann on Fri, 08/01/2014 - 10:30
It is time for me to get my rear in gear. I have tons of notes floating around on Oracle administration and performance related visualizations I would like to work on but without a deadline things start dragging out... Like when you have a weight loss or stop smoking goal that becomes real when you tell people about it.
Read more about 5 in 5 - 5 Oracle visualizations in 5 months...
Submitted by dmann on Wed, 06/25/2014 - 15:44
I gave my talk "Time for Some New Graphs: Incorporating Time and Animation Elements into Your Web App Visualizations" at KScope14 this week. As usual KScope has delivered on content and experts. I have been enjoying immersing myself in the Administration and Apex tracks.
Here are the slides to my presentation : Time For Some New Graphs - Slides
Submitted by dmann on Thu, 04/24/2014 - 15:05
Submitted by dmann on Wed, 04/16/2014 - 02:37
Well I have seen the light, there are a few ways to skin this cat and get into a more robust and interactive development environment.
Submitted by dmann on Wed, 10/30/2013 - 01:35
As the licensing of the Oracle Flashback Features has changed over recent releases I wanted to provide a summary. In 12c Oracle has opened up basic usage of Flashback Data Archive which is a handy way to add data archiving capabilities to existing/legacy applications.
The cost part of Flashback Data Archive is now an Optimization feature which reportedly will reduce the disk space requirements by 2-4 times. This requires an Advanced Compression license to use.
Submitted by dmann on Mon, 09/16/2013 - 18:38
I have been encountering a lot of Plus/Delta activity at the end of my meetings and projects. Basically it is an informal feedback mechanism. A chance to communicate 1) what was good about the meeting and 2) what may need to be changed in the future.
I can appreciate the sentiment. Just having a project or meeting leader ask for the feedback is a great step forward in improving processes. One of my group leaders took it a step further though when applying it to tasks or projects. Read more about A Delta to Plus/Delta... Good / Tricky / Different...
Submitted by dmann on Fri, 08/02/2013 - 04:16
Submitted by dmann on Thu, 08/01/2013 - 17:25
Submitted by dmann on Sun, 06/30/2013 - 10:56
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.