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