die Seilerwerks

Last week I was creating a new testing database from a backup of our demo database, both under Oracle 11.2.0.3. I grabbed one of my old scripts to handle the duplicate function, which looked similar to this:connect auxiliary /;run {        duplicate database to testdb                backup location '$BACKUPDIR'                nofilenamecheck;}One important difference... [Read More]

Fresh off the heels of my earlier composite partitioning post, I just ran into this confusing issue:SQL> alter table p_objects  2          add partition p201410  3                  values less than (to_date('2014/11/01','yyyy/mm/dd'))  4          (  5    ... [Read More]

As part of a project for work I wanted to create a script that would create a new range partition but also pre-create all the list subpartitions. By default the subpartitions would be created based on the subpartition template. However for various reasons which I won't get into we don't... [Read More]

A few weeks ago we upgraded one of our production server, adding another CPU tray. This brought the number of CPU cores from 80 to 160, and took us from 2Tb of RAM to 4Tb (just in time for Oracle to announce the in-memory database in 12.1.0.2!).However when I went... [Read More]

When the latest quarterly Patch Set Update (PSU) came out from Oracle, we planned to get it in place as soon as reasonable due to our need to stay current with security patches, and my need to apply what I had assumed were well-tested bug fixes for our 11.2.0.3 installations.... [Read More]