Submitted by dave on Thu, 09/15/2016 - 17:49
To troubleshoot a problem I needed to copy a database's worth of files out of an ASM diskgroup and onto the filesystem. I searched around and checked help for ASMCMD assuming there was a recursive option. I found references to one in some places on the interwebs, even official Oracle references to it like Unable To Copy Directory Using ASMCMD Cp -r Command (Doc ID 829040.1) but struck out when trying to do this on 11g and 12c ASM installs.
Submitted by dave on Wed, 04/27/2016 - 12:24
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.
Submitted by dave on Tue, 03/08/2016 - 11:23
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 for this and I found some methods for calculating Network Bandwidth but I wanted to start with raw redo generated from an instance using information from v$archived_log.
Submitted by dave on Mon, 02/08/2016 - 12:06
I was recently asked to update the EBS Plugin from 220.127.116.11.0 to 18.104.22.168.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 which incompatible versions of these plug-ins have been deployed."
Submitted by dave on Fri, 03/06/2015 - 12:20
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.
Submitted by dave on Thu, 03/05/2015 - 11:26
Submitted by dave 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.
Submitted by dave 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.
Submitted by dave 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 dave on Thu, 04/24/2014 - 15:05
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