May 16, 2017
Oracle 12c: The Online Datafile Move
One of my favorite new features in Oracle 12c is probably the online datafile move. Previously, a tablespace had to be offline to move a datafile – which can be difficult to do with a live, busy production database. Getting downtime on a 24/7 system for a maintenance task can take quite a bit of time. Not to mention the numerous
May 12, 2017
Resolving ORA-00054: resource busy and acquire with NOWAIT specified
Oracle’s RDBMS as a product is comprised of thousands of tweakable settings and parameters. Even for someone who works with it every day and actively reads articles on Oracle-related topics and features, useful stuff often still slips through the info net until something hits the wall and you have to dig into a specific usage scenario or error. Here’s what
May 5, 2017
Oracle 12.2 “On Premises” Now Available
Yes folks, it is out there!
November 7, 2016
SQL Server 2016: A Look Inside the Stretch Database
Many industries require keeping records that go back for several years. However, in reality, only records going back one or two years are often accessed. These non-accessed records are referred to as “cold data.” Cold data, while rarely accessed, still takes storage space and processing speed.