Killing a persistent DBMS_JOB...

I had a job associated with a badly performing MView. The MVIew performance caused the job to be active all the time because it was refreshing 24/7. In this Oracle document we have the statement: Stopping a Job: Note that, once a job is started and running, there is no easy way to stop the job.
Challenge accepted...
Read more about Killing a persistent DBMS_JOB...

Getting the Most out of SQL Developer User Defined Reports - Presentation and links...

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. A PDF of my presentation is available here:

DMann-SQLDeveloper4Reporting.pdf Read more about Getting the Most out of SQL Developer User Defined Reports - Presentation and links...

October - Visualization 2 - SQL Developer to d3.js Node Graph

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 can drive a d3.js visualization directly from a SQL Developer custom report. Read more about October - Visualization 2 - SQL Developer to d3.js Node Graph

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. Read more about August - Visualization 1 - SQL Execution Plan Volatility

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. Read more about 5 in 5 - 5 Oracle visualizations in 5 months...

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 Read more about Slides and Scripts for Data Auditing in Oracle

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.
Read more about Live Coding with JavaScript

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.

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. Read more about A Delta to Plus/Delta... Good / Tricky / Different...

Pages

Subscribe to ba6.us RSS