Last week at our company we organized a session about NoSQL in general and MongoDB in particular, as you can read here. The MongoDB focus was presented by me and I would like to take you with me on my trip to actually appreciating the NoSQL database world (and MongoDB […]
Serial database backups using Oracle Enterprise Manager
For several years now, I’ve been a fan of backups controlled by Enterprise Manager (of Grid Control, or Cloud Control, call it what you want). It is relatively easy to configure backups for your databases and it is well known in our DBA world. Only one thing bothered me though, […]
Oracle X5-2, from bare metal to VM Server. Without disks, without dvd drive.
Oracle offers a fine machine called the X5-2. Not to be confused with the ODA X5-2, which comes with sophisticated database software. The X5-2 is just bare metal. The X5-2 is a 1HE 2 socket Intel machine with limited configuration options in terms of processor speed, number of cores and […]
Using guaranteed restore points to navigate through time
Some months ago I worked on a project where we thought it would be a good idea to use multiple guaranteed restore points to be able to navigate through time back and forth. Sadly we ran into some unexpected behaviour of the Fast Recovery Area. Prologue. This was basically a […]
Cloud Control Agent 12c managing many objects
An Oracle Enterprise Management Agent 12c that has to manage hundreds of objects needs extra tweaking. If not, it will not start, or it will die soon, leaving you with an unmanaged infrastructure. Situation The customer runs over 200 databases on 1 host. Intel bases host with 384GB RAM and […]
Very first experience with oracle Cloud Service
Recently I found myself in the unique position of having access to the beta version of the Oracle Cloud to get a glimpse at the future as Oracle sees it. This blog describes my personal experience and does not necessarily reflect Oracle’s point of view. That said, the cooperation with […]
Materialized views: fast refresh, complete refresh or recreate?
Have you ever wondered why it takes a century to completely refresh your materialized view? I did, so I did some testing. Recently I was asked to support a customer whose database was extremely slow. As it turned out, some indexes had been created on a materialized view and that […]
Oracle InMemory compared to indexing
In August 2014 Oracle released its RDBM 22.214.171.124 with a potentially useful and exiting new option: Database InMemory. Upon reading about it it became clear to me that this is a powerful option, worth examining deeper. This blog will briefly describe what InMemory is and what it isn’t. The emphasis […]
Oracle Restart to autostart your oracle database, listener and services on linux.
Half a year ago, my colleague Remco wrote an article on auto starting the listener and the databases after a host reboot. As usual with Oracle, there are several solutions. In a previous job, I learned to appreciate Oracle Grid infrastructure to do the same. And then some more. Oracle […]