Add Code w/ Syntax Highlighting to PowerPoint

Uncategorized
| Feb 6, 2013
…or any media that supports rich text or HTML. I often include code-snippets or queries in technical presentations. I find them much more visually appealing and easier to read if they include syntax highlighting. If you’re using Notepad++ on Windows, it’s trivial. Simply go to the “Plugins” menu > “NppExport” > “Copy all formats to [...]

“Refresh” a CSV File

Uncategorized
| Feb 5, 2013
In a previous post I discussed a PDF reader that allows you to refresh the PDF after changes are made. This is the same concept except it’s for CSV files. I’ve been using Perl to convert sqlplus spool output to CSV which is much easier to read into R. As I’m updating my code and [...]

“Refresh” a PDF

Uncategorized
| Feb 5, 2013
I’ve been working in R (wikipedia entry) a lot lately to graph performance data about Oracle systems. In general I output PDF files. The problem with most PDF readers (on Windows) is that they either get an exclusive lock on the file when it’s open (yes you, Adobe Acrobat), or you have to close and [...]

Scripted Collection of OS Watcher Files on Exadata

Uncategorized
| Nov 2, 2012
I’ve been working a lot with graphing DB and OS metrics in R. I find it especially useful in Exadata POVs (proof of value) to gather and graph the oswatcher vmstat files for the compute nodes and iostat for the cells. For an example, take a look at this graph (PDF, 168 KB) of what [...]

Speaking at Enkitec Extreme Exadata Expo

Uncategorized
| Aug 9, 2012
I’ll be speaking at the Enkitec Extreme Exadata Expo (E4), August 13-14 in Dallas Texas (you can also attend virtually). They’ve recruited some of the top names from community including keynote speaker Andrew Mendelsohn, Arup Nanda, Cary Millsap, Jonathan Lewis, Karen Morton, Maria Colgan, Kerry Osborne and Tanel Põder. I left a lot of names off the list, many of which you probably [...]

Convert sqlplus spool output to CSV

Uncategorized
| Apr 11, 2012
I’ve been doing some work lately with sizing / capacity planning where the source are a few of Karl Arao’s excellent AWR Mining scripts. Had I been reading his blog more I would have known he was going down a parallel path using Tableau as I was moving in the direction of R.  Anyway, I [...]

Create Bigfile Tablespace – Oracle Managed Files (OMF)

Uncategorized
| Feb 10, 2012
Working with Exadata a lot (almost exclusively) I create almost all my tablespaces as bigfile using OMF. For some reason I can never find the right syntax for this when I need it. So, that’s the main reason for this post. On a related note, wow I use “column mode” in Notepad++ (link) a lot [...]

I Need More Hardware!

Uncategorized
| Feb 8, 2012
Actually, this is one of the few times I can remember in my career when I can honestly say I have enough horsepower at my disposal. Want to guess what I’m running right now? This POV will probably generate a number of follow-up posts. One concept: there are always bottlenecks. When you remove the hardware [...]

Oracle Database 10.2 De-Supported

OK, that’s an alarmist title and is not really true. However, I feel this topic is important enough to warrant the title. I’ve talked to a lot of people lately that were not aware of the actual support status of Database 10.2 and below (it changed on July 2010 and the 1 year grace period […]

Logger Project Moved Temporarilly

Uncategorized
| Nov 9, 2011
The site samplecode.oracle.com was decommissioned recently. I was hosting a number of projects there including “Logger”, my PL/SQL instrumentation package. Until I find a new home, here’s a temporary link to the latest release (1.4) or if you just want to view the readme use this link. I’ll update this post when I decide on [...]