Dave (130)

Dave

PowerDesigner Annoyances 1

Yes, I tagged it with a '1' because I already know there are more to come :) I created a notebook on this site to collect information about PowerDesigner. My first entry deals with basic script generation options for Oracle and how to get better…

Dave

Updated Heat Map Report

During my preparation for a visualization presentation at East Coast Oracle Users Group I realized I had an opportunity for a teaching moment on Levels of Abstraction. A few months back I published my PL/SQL code for an Archived Log Switch Heat Map. Below is…

Dave

myBatis Migrations and Oracle RDBMS

I am evaulating some schema migration tools for a project I am working on. I want some basic help organizing scads of changes that we will make during development. I also want the ability to produce generic SQL scripts as output to pass along for…

Dave

Using Google Charts API and SQL Developer (or SQLPLUS)...

I added a page to my SQL Developer Tips and Tricks page about integrating the Google Graph API with SQL Developer HTML reports. I sometimes run out of steam with the built in chart and gauge capabilities of SQL Developer. With a little work you…

Dave

V$OBJECT_MONITORING gotcha...

I have been checking out some usage patterns on a database I am migrating to Exadata. I won't go into the 'drop all of the indexes' herd mentality... but I would like to know what is really being used on this system so we can…

Dave

Archived Log Switch Heat Map for SQL Developer...

... or just use SQLPLUS to spool to HTML and open with a browser if you are old school :) I am on week 4 of my newly reimaged work laptop sans Toad. I am trying to make a go of things with SQL Developer…

Dave

Golden Gate Lag Graph + Alerting scripts on the way...

I posted my GoldenGate / Gnuplot lag time alerting shell scripts to a new GitHub repository: http://github.com/dmann99/ggtools The scripts worked on v8 and I don't think the INFO ALL screen has changed much since then so hoping it will work on v11 with a minimum…

Dave

This is why we can't have nice things...

This is probably old hat for most of my audience but I needed to get this down on paper (or bits actually) for posterity... The granularity of Oracle privileges leaves a lot to be desired. Today I had a requirement for an application program to…

Dave

We're upgraded... but excuse the dust...

After lots of wrassling with the Drupal schema we're up and running on Drupal 7. Sometimes it is a pain to be a DBA. I couldn't just let the problems with the schema upgrade alone and built my own script to fix issues so I…

Dave

Parallel Processing Shell Script - SQLPLUS example...

I have a data collection system that I run against all DBs in my environment nightly. I inherited a script that would just start at the top of the list and SQLPlus into them one by one to collect the data. Well the scope of…

Dave

Strawberry Perl + DBD::Oracle for MS Windows...

While helping a developer at my company get up and running with some DBI/DBD stuff I came across the Open Source Strawberry Perl distribution for Windows. It is an all-in-one package of Perl interpreter and many common packages required to get productive. Hopefully gone are…