Submitted by david on Fri, 01/23/2015 - 14:30
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.
Read more about Killing a persistent DBMS_JOB...
Submitted by david on Tue, 12/09/2014 - 11:59
Submitted by david on Sat, 11/01/2014 - 15:43
Submitted by david 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 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
Submitted by david 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 david 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 david on Thu, 04/24/2014 - 15:05
Submitted by david 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 david 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 david 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...