The Archives
-
15 Mar 2022 - Encoding Lazy-Loaded Values in Chef for HTTP Authentication
-
23 May 2021 - Speeding Up PostgreSQL Recovery with pgBackRest
-
18 Nov 2020 - Unattended Upgrades, Ubuntu 18.04, and PostgreSQL 10: The Perfect Storm
-
02 Oct 2018 - Sequence Caching: Oracle vs. PostgreSQL
-
01 Jul 2018 - NULL Means NULL
-
05 Jun 2018 - Altering Default Privileges For Fun and Profit
-
11 May 2018 - USAGE Privilege Prevents Dropping Users
-
11 May 2018 - Moved to GitHub Pages
-
30 Apr 2018 - Beware (Sort-Of) Ambiguous Column Names In Sub-Selects
-
14 Apr 2018 - How (Not) to Change Passwords in PostgreSQL
-
09 Feb 2018 - The Transition (or: How I Learned to Stop Worrying and Love PostgreSQL)
-
28 Jan 2016 - Sending notifications from Oracle Enterprise Manager to VictorOps
-
10 Nov 2015 - Just XFS Things
-
21 Jul 2015 - The Leap Second is No Laughing Matter (if you have java on an older Linux kernel)
-
21 Jul 2015 - Upgrade to Oracle 12c, Get the Huge Trace Files for Free!
-
06 Jan 2015 - Returning Error Codes from sqlplus to Shell Scripts
-
12 Nov 2014 - Making Copies of Copies with Oracle RMAN
-
04 Nov 2014 - The Importance of Backups (A Cautionary Block Recovery Tale)
-
22 Oct 2014 - ORA-16534 When Converting to/from Snapshot Standby with DataGuard Broker
-
01 Oct 2014 - Advanced Queue Quickie: Errors and Privileges
-
10 Sep 2014 - NOFILENAMECHECK Parameter Causes DUPLICATE DATABASE To Ignore DB_CREATE_FILE_DEST?
-
21 Aug 2014 - ORA-14048 When Adding Composite Partition
-
21 Aug 2014 - Adding New Partitions with Custom Subpartition Definition (Range-List)
-
13 Jul 2014 - ASM Startup Fails With ORA-04031 After Adding CPUs
-
03 Jun 2014 - Beware April 2014 PSU and Golden Gate Integrated Capture Users
-
12 May 2014 - archive_lag_target Works in SE
-
25 Apr 2014 - Don’t Fear the EM12c Metric Extensions
-
17 Apr 2014 - Supplemental Logging and Securefiles Causing DBWn to Block
-
15 Apr 2014 - RMAN Redundancy is not a Viable Retention Policy
-
07 Apr 2014 - Migrating (and Upgrading!) Your EM12c Repository Database
-
30 Mar 2014 - ORA-00600 [kkzlpllg:5] When Dropping MView Log
-
26 Mar 2014 - Battling Bigfile Backup Bottlenecks
-
16 Mar 2014 - Why Is My MView Log Not Purging?
-
12 Mar 2014 - What to Expect When You’re Changing the DB_UNIQUE_NAME
-
05 Mar 2014 - Oracle Direct NFS and Infiniband: A Less-Than-Perfect Match
-
28 Feb 2014 - The Danger of Moving Incrementally Updated Datafile Copies
-
28 Jan 2014 - ZFSSA EM12c Plugin Pro-Tip
-
22 Jan 2014 - Upgrading EM12c to 12.1.0.3: Active Directory Authentication Quirks
-
04 Dec 2013 - shutdown abort: Not always “fine”
-
22 Nov 2013 - Oracle Direct NFS (and Linux Routing) … for Dummies!
-
11 Oct 2013 - UNTIL CANCEL UNTIL CANCEL UNTIL CANCEL
-
10 Oct 2013 - Oracle Restart Underscore Warning!
-
15 Feb 2013 - Views, Datatypes and Nulls
-
02 Feb 2013 - Learning to Love the ADR - Part 4: Incident Packaging Service
-
30 Jan 2013 - Learning to Love the ADR - Part 3: Purging (Out With The Old)
-
29 Jan 2013 - Learning to Love the ADR - Part 2: Diagnostic Files and ADRCI
-
26 Oct 2012 - Learning to Love the ADR - Part 1: Location, Location, Location!
-
16 Feb 2012 - Me at RMOUG
-
15 Feb 2012 - A NoCOUG to Remember
-
15 Feb 2012 - Upgrading Standalone ASM to Oracle Grid Infrastructure 11.2.0.2? Beware Bug 10283819!
-
15 Feb 2012 - Using a Custom Timezone? Beware Oracle 11.2.0.2 Grid Infrastructure!
-
03 Jun 2011 - Vote for my session for Oracle OpenWorld 2011!
-
03 Jan 2011 - Upgrading Standalone ASM to Oracle Grid Infrastructure 11.2.0.2? Beware Bug 1233183.1!
-
27 Dec 2010 - I Do Not Think It Means What You Think It Means
-
19 Nov 2010 - Back to Blogger!
-
12 Nov 2010 - Beware the /var/tmp/.oracle Hidden Directory!
-
30 Jun 2010 - Installing Oracle 11gR2 Enterprise Edition on Ubuntu 10.04 (Lucid Lynx)
-
30 Jun 2010 - Applying Oracle 11.2 April 2010 PSU for Single-Instance ASM and DBMS
-
22 Nov 2009 - A Drupal Backup Script
-
27 Oct 2009 - Moving Oracle Datafiles to a ZFS Filesystem with the Correct Recordsize
-
27 Oct 2009 - HOWTO: Oracle Cross-Platform Migration with Minimal Downtime
-
26 Aug 2009 - Turn Off db_cache_advice To Avoid Latch Contention Bugs
-
19 Aug 2009 - Setting up Network ACLs in Oracle 11g… For Dummies
-
19 Aug 2009 - Sending Timezone-Aware Email with UTL_SMTP
-
19 Aug 2009 - ORA-16069? You May Need A New Standby Controlfile
-
01 Oct 2008 - GNU basename in PL/SQL
-
01 Oct 2008 - Does Oracle’s Block Change Tracking File Shrink?
-
30 Jun 2008 - FLASHBACK TABLE vs. DBA_OBJECTS.LAST_DDL_TIME
-
09 May 2008 - Moving On Up
-
06 May 2008 - Helpful Hints for RMAN Recovery
-
23 Apr 2008 - Bind Variables and Parallel Queries Do Not Mix
-
18 Apr 2008 - Don: 1 vs. 1Z0-043: 0
-
18 Apr 2008 - Some Comic Humor For You
-
14 Apr 2008 - ALTER TABLE doesn’t like synonyms
-
29 Mar 2008 - netca and /etc/hosts
-
26 Mar 2008 - Moto RAZR + Bluetooth + Linux + Python = ObexCopier
-
29 Jan 2008 - v$sql_bind_capture Not Quite Capturing SQL Binds
-
19 Dec 2007 - A Sub-Prime I/O Primer
-
01 Dec 2007 - DBWR and the Devil
-
21 Nov 2007 - Greg Rahn Explains Plans
-
21 Nov 2007 - Scalar::Util on CentOS5 is Bustinated
-
13 Nov 2007 - Tuning Backup & Recovery
-
31 Oct 2007 - OTN downloads may not be supported!
-
30 Oct 2007 - Patchwork
-
19 Oct 2007 - python + cx_Oracle = <3
-
19 Oct 2007 - Want to install Oracle on CentOS 5?
-
10 Oct 2007 - On SQL Injection
-
09 Oct 2007 - Following Up re HALP
-
21 Sep 2007 - The Powers of Certification
-
20 Sep 2007 - HALP
-
18 Sep 2007 - TORA LIVES
-
16 Sep 2007 - BEST. LOAD. EVER.
-
11 Sep 2007 - Understanding System Statistics
-
11 Sep 2007 - How I Prepared for the Oracle 10g OCA Exam
-
07 Sep 2007 - The Perils and Pitfalls of the Foreign Key Constraint Cascading
-
06 Sep 2007 - Debunking the Buffer Cache Hit Ratio
-
05 Sep 2007 - I R OCA
-
17 Aug 2007 - Dr. Statslove or: How I Learned to Stop Guessing and Love the 10053 Trace
-
17 Aug 2007 - DBWR 101
-
17 Aug 2007 - Oracle SQL Developer 1.2.1.32 released
-
11 Jul 2007 - ZOMGWTFBBQ11G!
-
11 Jul 2007 - Gathering stats for ONLY a partition
-
11 Jul 2007 - CONNECT role, we hardly knew ye.
-
06 Jul 2007 - TWO_TASK is actually still used.
-
05 Jul 2007 - The Story of RMAN Duplication and the Pre-Existing Tempfiles
-
29 Jun 2007 - On histograms
-
27 Jun 2007 - I’m Kind of a Big Deal Around Here
-
06 Jun 2007 - What Is NULL?
-
06 Jun 2007 - Oracle Licensing (or: WTF Partitioning?!)
-
06 Jun 2007 - Perils and Pitfalls in Oracle Partitioning: Bind Variables?
-
06 Jun 2007 - Joining on substrings
-
02 Jun 2007 - LOL/SQL?
-
01 Jun 2007 - CSALTER requires a clean CSSCAN
-
29 May 2007 - Changing Oracle Database Character Sets
-
21 May 2007 - An end to my Oracle listener hanging
-
21 May 2007 - Tuning the PGA: The Follow-Up
-
15 May 2007 - ASM, we hardly knew ye
-
14 May 2007 - ASMM, we hardly knew ye.
-
10 May 2007 - Wherefore art thou, Development DBA?
-
10 May 2007 - Oracle SQL Developer 1.1.3 is out
-
10 May 2007 - I’m kind of a bigger deal around here now
-
08 May 2007 - Hiding “Permission denied” errors with
find
-
02 May 2007 - Back to Basics: Joins
-
02 May 2007 - Multi-Table Inserts: A Serendipitous Tale
-
27 Apr 2007 - More Log Buffer Pity
-
27 Apr 2007 - Writing SQL Developer Reports
-
25 Apr 2007 - ASMM Pitfalls
-
25 Apr 2007 - Feuerstein on Error Tracing
-
25 Apr 2007 - BEST HELP REQUEST EVAR!!!!!11
-
23 Apr 2007 - Oracle PL/SQL Best Practices and Common Mistakes
-
15 Apr 2007 - Quick Review of Oracle on CentOS (RHEL) 5
-
15 Apr 2007 - SQL for the Childrens
-
15 Apr 2007 - sprintf() in PL/SQL
-
15 Apr 2007 - Christo on Aligning ASM Disks on Linux
-
12 Apr 2007 - Optimizing through Understanding
-
10 Apr 2007 - Heart of Darkness
-
09 Apr 2007 - Caveats for renaming a server running ASM
-
09 Apr 2007 - Things You Know: Tom Kyte is Under Siege
-
06 Apr 2007 - Log Buffer #39: The April Fool
-
05 Apr 2007 - 200 is such a hard number to work with, after all
-
04 Apr 2007 - Using NOT LNNVL() is NOT GOOD()
-
03 Apr 2007 - I have not yet begun to fight!
-
03 Apr 2007 - PGA: Not just for Caddyshack 2 fans
-
30 Mar 2007 - IT’S THE JOIN[T]!
-
30 Mar 2007 - I’m on the clock …
-
26 Mar 2007 - Appreciating Oracle’s Read Consistency
-
26 Mar 2007 - Why Wait?
-
22 Mar 2007 - How to Find Blocking Locks and Influence People
-
20 Mar 2007 - ojdbc vs. gcj
-
15 Mar 2007 - Saving Daylight for Oracle EM dbconsole
-
09 Mar 2007 - 40 Tips from Tom Kyte
-
09 Mar 2007 - It’s an SGA Explosion!
-
08 Mar 2007 - Fight the Lockdown
-
08 Mar 2007 - ATTN Python Lovers: A New cx_Oracle Awaits You!
-
06 Mar 2007 - Dynamic Listener Registration
-
06 Mar 2007 - asmcmd: command-line tool for ASM
-
06 Mar 2007 - Fixing a 32-to-64-bit Migration with utlirp.sql
-
05 Mar 2007 - Oracle SQL Developer 1.1.2 released
-
28 Feb 2007 - Oracle Parallel Basics with Doug Burns
-
28 Feb 2007 - For Great Justice!
-
26 Feb 2007 - lnnvl() ftw
-
26 Feb 2007 - Data and Datatypes
-
23 Feb 2007 - Stealing My Material: or How I Though of Blogging About v$sql_bind_capture before hali did
-
19 Feb 2007 - Role Showdown: CONNECT vs RESOURCE
-
13 Feb 2007 - What is so special about SYSDBA?
-
08 Feb 2007 - Honorable Mention
-
08 Feb 2007 - ASSM IS EVIL!!!!!!11
-
01 Feb 2007 - Comparison of different SQL implementations
-
30 Jan 2007 - Interpreting Query Plans
-
18 Jan 2007 - The Four Options of the SHUTDOWN
-
17 Jan 2007 - Truth, Justice, and …
-
16 Jan 2007 - The Worth of Certifications
-
09 Jan 2007 - sqlplus commit-on-exit?
-
09 Jan 2007 - Temporary Tables and REDO Logs
-
08 Jan 2007 - Track yer block changes
-
05 Jan 2007 - selecting count(1) vs count(*)
-
04 Jan 2007 - Happy New Year
-
19 Dec 2006 - Bind Variables: Not just for SELECTs!
-
18 Dec 2006 - NEVER
-
12 Dec 2006 - Java5 Formatting Goodness
-
11 Dec 2006 - Monitor RMAN I/O
-
08 Dec 2006 - Apocalypso
-
06 Dec 2006 - Analytics FTW
-
05 Dec 2006 - #oracle-wtf
-
04 Dec 2006 - Keep Oracle Docs Handy
-
30 Nov 2006 - today in #oracle
-
28 Nov 2006 - How The Oracle Database Processes SQL Statements
-
28 Nov 2006 - Bind Your Variables or Die
-
15 Nov 2006 - Functions Can Trump Indexes
-
14 Nov 2006 - set autotrace traceonly
-
10 Nov 2006 - Constraints and the CBO
-
10 Nov 2006 - Compound Primary Keys Must Die
-
07 Nov 2006 - Reverse Key Indexes
-
31 Oct 2006 - On the Oracle vs RedHat thing …
-
30 Oct 2006 - tkprof fun under the sun
-
23 Oct 2006 - Oracle Docs Firefox Search Plugin and Extension
-
23 Oct 2006 - Today’s Oracle <3: Proxy Users
-
20 Oct 2006 - python + oracle == <3
-
11 Oct 2006 - Origins of Days and Oracle’s DATE
-
03 Oct 2006 - Partition Exchange for fun and profit