During my one year stint as a Sr. Instructor at Oracle University I got to meet with a lot of current and aspiring DBAs. While I’m most at home in front of a computer with thirty clients breathing down my neck, a fat mug of coffee and a pile of
Tag: Oracle
Big Data (Ace Comic)
For your weekend pleasure (and back after many years), a new Adventures of Ace, DBA comic! Don’t forget to check out Big Data #2 – Big Data Speaks!
These Aren’t the Metrics You’re Looking For
Oracle is well known as a complex environment, and with good reason. Though they will object to that complexity at the sales level, they embrace it at the technical level. Let’s forget for a moment the pains this may have caused us in our careers and focus on an undeniable
Cloning Your Oracle Installation
If there is one thing a DBA hates it is to waste time. Particularly on boring and tedious tasks. One such task is installing Oracle on a new system (or duplicating a home on an existing system) which generally involves X server setup (Xming for Windows, XQuartz on Mac, pure
Oracle GoldenGate in the Enterprise
GoldenGate – The Bridge to Everywhere Oracle GoldenGate has generated a lot of buzz in the Oracle community since the software was purchased by Oracle in 2009. It is marketed by Oracle as a niche application, but one that can be of use in nearly any Oracle environment. Additionally, Oracle
Add History and Tab Completion to SQLPlus
In the uncharted backwaters of the Internet there exists a really awesome tool called rlwrap. This readline wrapper is able to call programs that are deficient in modern amenities like history, color, and tab completion, intercept input/output, and replace it as necessary with useful goodies. And what program could be
A Few Words on Oracle Licenses
Despite reams of legalese and countless blog/forum posts, basic Oracle RDBMS licensing still remains a mystery to many. While I won’t even begin to discuss components like Oracle Apps, hopefully this post may help you attain a basic understanding of Oracle, what you can license, and what it costs. Editions
Deploying Outside the Box
I’ve been on quite a “broaden your horizons” kick lately, as evidenced by my team and DBA development posts and ultimately the Database Diversity series (in progress). But I truly think it is important to keep not only aware but conversant in emerging technologies both for your personal benefit and
The Overly Shared Pool
Ever been in a really crowded pool? I have… and chances are so have your queries. This article will go into a little bit of high level detail about the shared pool and a portion of what it does for us, then show a real “good pools gone bad” issue
DBA, Grow Thyself – Moving and Shaking in the Era of Data Dominance
Beefing up your technical skills is important, and it’s what makes you a good DBA, Developer, Architect, or whatever you happen to be. But at the same time, it is incredibly important to keep up with the professional trends in your organization. While all organizations are different, there are some