After 4 unexplained crashes and a stalled Sev 1 SR I was pulling my hair out. Particularly vexing was the fact that a user was running a distributed query which was crashing a remote database. I isolated the 4 crash times for the remote database…
I recently came across a legacy database that was using Oracle FLOAT datatype for Primary and Foreign Keys. As the database needed some attention I was asked to get data types in order and get rid of the FLOATs in favor of NUMBER data types.
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…
I was recently asked to update the EBS Plugin from 12.1.0.2.0 to 12.1.0.3.0 in my Cloud Control 12 setup. During the prereq steps I got an error: "EM-04050: The selected plug-ins cannot be deployed on the Management Server because there are some Management Agents on…
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…
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…
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…
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…
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…
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…
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…
I have a case where I need to enforce uniqueness on a combination of columns but only when a flag is set (ACTIVE_FLAG=1). The table also holds history and may have multiple inactive records mixed in but I don't want to keep those from being…