Submitted by dmann on Fri, 02/24/2017 - 17:03
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 and I wanted to see what users and SQLs were running on the local database up until the crash time. So for a crash happening around 11:16 I would use the following query.
Submitted by dmann 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 dmann 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 dmann 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 dmann on Mon, 02/08/2016 - 12:06
I was recently asked to update the EBS Plugin from 126.96.36.199.0 to 188.8.131.52.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 dmann 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 dmann on Thu, 03/05/2015 - 11:26
Submitted by dmann 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 dmann 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 dmann 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