List/Grid Tag Archives: Oracle
Fundamentally Irrelevant
There’s always a risk when you go off testing something that you notice some side-effect or issue that turns out to be irrelevant to the main investigation. I’ve been investigating a performance problem on an insert .. select statement. For the last couple of days, I’ve had a physical copy of the production database from [...]
Oracle Documentation: The broken links fiasco continues…
So I was just patting myself on the back for finishing my website clean up, then I happened on a few pages with broken links to Oracle documentation. That annoyed me, but I figured I better do a quick scan to see how many broken external links I had. The first attempt was a complete [...]
Log Buffer #256, A Carnival of the Vanities for DBAs
Searching for the blogging inspiration? On the look-out for that Eureka moment for your next blockbuster blog post? Finding the exact ingredients for your dream rambling? Well in the Log Buffer Edition, there are some awe-inspiring posts in this Log Bu…
RIP Flash-based My Oracle Support
The end is nigh for Adobe Flash at My Oracle Support. The first step will happen during this weekend’s planned maintenance of My Oracle support, when all of MOS will be down for 5 hours starting at midnight eastern, Saturday January 28. Once it c…
Ouch!
Here’s a set of Instance Activity stats I’ve never seen before, and I’d rather never see again. From an active standby running 11.1.0.7 on AIX: The instance has been up for about 60 hours – and 95% of the work it has done has been trying to find the commit times for transactions affecting blocks [...]
Nested Tables 101
From An Expert’s Guide to Oracle Technology
A nested table is much like an associative array but you do not determine the index. The index grows by using the extend command and the index is always an incrementing integer value. You ca…
Pythian at RMOUG Training Days 2012
Pythian is very excited to return to the much-awaited RMOUG 12 held in Denver, Colorado from February 14-16, 2012. Keep your eyes open for Alex Gorbachev, Marc Fielding, Don Seiler and Gwen Shapira in attendance. We have a fantastic line-up of speakers…
Resumes & Job Objectives
I’ve been reviewing a lot of resume’s lately. Please tell me, what is the purpose stating your "Job Objective"? Isn’t it implied that your objective is to find a new job, specifically my job? I assume you’re dynamic and technical and your vast expertise will help my company conquer the world.
Also, what is the purpose of summarizing your experience on the first page and then giving me eight
The Proof is in the Pudding
The majority of technology sales, particularly in software, require some sort of proof of concept (POC) intended to prove out the product(s) based on a customer’s requirements. Syncsort is no stranger to POCs and we have a record of producing some really impressive results. Recently, we had the opportunity to present some of these results [...]
The Proof is in the Pudding is a post from the Syncsort blog. Copyright © 2012 Syncsort, All Rights Reserved.
Interesting Bug
Michael posted a comment on Martin’s blog, that I previously quoted, about a “hack” to add a comment on a default value definition. Here is an example of how it works (tested in 11.2.0.1): SQL> CREATE TABLE t ( 2 x VARCHAR2 (10) DEFAULT ‘Hi’ — There. This will be stored too. 3 ); Table [...]
