Database Performance: A Guide to Tools and Analysis

If your business thoroughly understands how to leverage the information that is gathered and stored in your company database can be crucial to better understanding your audience and improving your business. Your database is often used to make important decisions on the direction of your company and it’s vital to ensure that your database is […]

Use This 11g Workaround to Bypass Statspack Bug

If you have an 11gR2 database (we’ve seen it on 11.2.0.2 databases although it may be present in 11.2.0.3 as well) and you get this error when trying to run a Statspack snap: ORA-00001: unique constraint (PERFSTAT.STATS$FILE_HISTOGRAM_PK) violated ORA-06512: at “PERFSTAT.STATSPACK”, line 3813 ORA-06512: at “PERFSTAT.STATSPACK”, line 5079 ORA-06512: at “PERFSTAT.STATSPACK”, line 105 ORA-06512: at […]

Using OpenOffice Base with Oracle

Introduction Recently, I was doing some work with OpenOffice (OO), and I noticed a part of OO that I wasn’t aware of – the Base database. Base is similar to Microsoft Access, though it of course lacks some features and polish. It does come with the ability to interact with several different databases, the Oracle RDBMS among them. […]

Jump start your Datapump export job with this script

Every DBA should include Datapump, Oracle’s cross-platform data migration utility, in his toolbox, especially since the legacy export utility is slated for obsolescence.  Datapump expdp has a variety of uses, from database upgrades to QA refreshes and logical backups.  A great place to start is with this script which has everything you need to do […]

An introduction to emacs SQLi mode

Introduction Early in my career, when I was first introduced to Unix, my mentor at the time recommended that I use a text editor called emacs, but also learn how to use vi as well. I personally like both editors, but I prefer emacs for coding. Over the decades, I’ve continued to use emacs; I […]