Leveraging Data: How to Improve Your Business

Understanding the information that your business is collecting is crucial, but learning how to leverage that information to better your business relationships is by far more important. Often times, the information is gathered but not necessarily sorted into a digestible or useful forms and therefore requires you to sift through the information and figure out […]

Understanding UNDO

Sooner or later, every Oracle DBA will hit a problem of some sort that is related to the concept of Oracle “Undo”. The Oracle Undo performs a few very important functions in the database; these being the support of read-consistent queries and Flashback queries, supporting transactions (COMMIT and ROLLBACK), and recovering from database crashes. Along […]

Just the basics; managing Oracle disk space

Introduction Here’s a quick quiz; of all of the problems that can beset an Oracle database, which one happens the most often? Do you think that it’s concurrency or locking issues? Issues with CPU being overwhelmed, or disk I/O rate being overwhelmed? Oracle internal bugs? Disk space issues? Problems encountered with backup & recovery? Account […]

Just the basics; Upgrading the Oracle RDBMS

Introduction This is the first installment of a series of shorter whitepapers that just cover the basics of a particular aspect of the Oracle RDBMS. The first one is on the subject of upgrading Oracle. After doing literally hundreds of Oracle RDBMS upgrades and patches over the past 18 years, these are my recommendations. Why […]

A quick introduction to dbms_pipe

One thing about working with PL/SQL is the fact that it runs inside the database (Oracle Forms nonwithstanding), rather than in a normal OS process. This means that any interaction with the database server OS itself isn’t easily possible. You can create a library in ‘C’ and call that from pl/sql, but this isn’t usually […]