dave's blog

August - Visualization 1 - SQL Execution Plan Volatility

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 to identify Execution Plan volatility. When researching performance problems I often need to quickly digest historical performance of a trouble statement - a statement that usually has run fine for years but now has started acting up.

5 in 5 - 5 Oracle visualizations in 5 months...

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.

Slides and Examples for Time for Some New Graphs...

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

Slides and Scripts for Data Auditing in Oracle

I am currently getting my mind blown by Craig Shallahamer's Oracle Conference on the James presentation on Detailing Oracle CPU Consumption... But earlier today I was able to give my talk on Oracle Data Auditing... Well minus the demos because I need to get better about cutting out slides.

Here are the links to the slides: DataAuditingConceptsAndImplementation.pdf

Live Coding with JavaScript

I have been messing around in JavaScript and d3.js a bit more than usual lately.

In the past my JavaScript prototyping environment was a collection of html/js/json files on my local disk and a basic HTTP server (like python SimpleHTTPServer). I would edit files and reload reload reload reload. Very tiresome. Not very "2014" if you ask me.

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.

Oracle Flashback Archive Licensing Info...

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.

table,td,th
{
border:5px grey;
}
td
{
border:1pm solid black;
}

A Delta to Plus/Delta... Good / Tricky / Different...

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.

Application Express and Open Source Graphing Libraries

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

A Brief Brief about a Brief KScope13 Visit...

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.

Pages

Subscribe to RSS - dave's blog