In my travels today I came across the Pythian Group’s Seven deadly habits of a DBA… and how to cure them.
Citing such pitfalls as blind faith in backups, lack of monitoring and finger pointing we’ve all seen these symptoms at one point or another, and they’re all worth some attention. While many of these are largely a product of inexperience I’ve seen my favorite, number 4, The Memory Test at all levels. The “if it happens again I’ll remember how we fixed it” syndrome is often a product of another environmental problem, a lack of documentation procedure. This exact problem is one reason I started blogging in the first place!
Check out the whole list, including their suggested cures for these problems.
dba, database, database administration, oracle
Andy C has posted a list of Oracle blogs he reads listed by Technorati ranking. Not only did Life After Coffee make the list, but it made #1!
Andy C posted a short history of Oracle blogging about a year ago. It seems there were a lot fewer back then.
Check out the whole list. There are some great folks on here, many of whom actually post primarily about Oracle!
oracle, database, dba, rdbms, blog
What follows is just a small taste of the 37 page PDF which is The Tao of Oracle.
Something is mysteriously formed,
Born before heaven and Earth.
In the silence and the void,
Standing alone and unchanging,
Ever present and in motion.
Perhaps it is the source of all code and data.
I do not know its name
I therefore call it the Tao of Oracle.
Truncate your mind.
Let the SGA become still.
The ten thousand transactions rise and fall
while the rollback watches their return.
They grow and flourish and then return to the disk.
Returning to the source is stillness,
which is the way of the Tao.
The instance has crashed.
I am the ORA 600.
No one hears your screams.
The bug you seek
Is found on Metalink.
You click the reference,
but it is non-published.
Roby Sherman at Interealm Software Imagineering did this “translation” of the Tao. The only thing that could possibly make this funnier would be if version 2.1 were referred to as 3T or some other seemingly arbitrary number and letter.
via Don Burleson.
humor, oracle, dba, geek, funny
While digging for some details on the NLS language settings in Oracle today I came across a great FAQ on the topic right on Oracle’s site.
The FAQ includes such topics as:
NLS_LANG Parameter Fundamentals
Checking the current NLS_LANG Settings
How to setup the NLS_LANG Property for UNIX
Where to set the NLS_LANG in Windows
A Whole Pile of Other Frequently Asked Questions
Check out the NLS_LANG FAQ if you’re looking to learn about the NLS_LANG and associated settings or to find the answers to many common questions on these parameters.
oracle, dba, database administration, system administration, UNIX, Linux
Nobody will argue that testing your code is an essential, but often neglected step to good development. Effective testing not of the whole application, but portions of it is the focus of the Oracle Development Tools User Group PL/SQL Test-A-Thon to be held Febuary, 28-March, 1 of this year in California.
Here’s how the challenge works:
After the end of sessions on the first day, you will be presented with four programs that perform typical operationsâ€”nothing exotic. Along with those programs come supporting test data, a list of tests that you need to perform, and the results you should get for each test (most will be successful, but some will fail). You will then have one hour to write a test to show which tests succeed and which fail for the programs. Your test results should be self-verifying. That is, we will not manually verify your tests to see if they worked or not.
Check out more about the contest and about the Oracle Development Tools User Group conference. While not overly active the Oracle Development Tools User Group site has some interesting content as well.
sql, plsql, oracle, development, software development, database, dba