Iggy Fernandez

Oracle DBAs most often find themselves working on Unix platforms and therefore some familiarity with Unix scripting is helpful. Utilities like “sed,” “awk,” and “grep” are often used in Unix scripts. Sed is a “stream editor” which filters and transforms the input stream. Awk is a pattern scanning and processing language named after Unix legends [...]

“In many of the more relaxed civilizations on the Outer Eastern Rim of the Galaxy, the Hitchhiker’s Guide has already supplanted the great Encyclopaedia Galactica as the standard repository of all knowledge and wisdom, for though it has many omissions and contains much that is apocryphal, or at least wildly inaccurate, it scores over the [...]

I have on good authority from a NoSQL aficionado that “the only requirement from NoSQL is to be non-relational, and therefore without joins.” Obviously if relational joins are computationally expensive and NoSQL is a viable alternative then NoSQL wins. But are relational joins expensive by definition? Suppose that we have the following tables; the example [...]

FOR IMMEDIATE RELEASE Explosive Revelations about Dr. Edgar (Ted) Codd rock the NoSQL World San Francisco (April 1, 2012) – An explosive article titled A Relational Model of Data for Large Shared Data Banks published in the 100th issue of the NoCOUG Journal reveals that the late founder of the relational movement Dr. Edgar (Ted) [...]

POISED stands for “Problem Observation Implication Solution Execution Documentation.” It is the name I like to use for the systematic six-step troubleshooting method described by Chris Lawson in The Art and Science of Oracle Performance Tuning. Here is an example. Problem A batch job was running much slower than normal. The code had been deployed [...]

As published in the 101th issue of the NoCOUG Journal (February 2012) Whole New World with Baron Schwartz “A whole new world A new fantastic point of view No one to tell us no Or where to go Or say we’re only dreaming.” —Oscar-winning song from the movie Aladdin Baron Schwartz is the chief performance architect at Percona. [...]