I like to come upon new monitoring software that help to go quickly from user response time to root cause. And I love applications that can be installed easily and at which I can give a try without reading pages of manual. At DOAG 3rd floor I’ve visited the AppDynamics booth and immediately wanted to install the trial version and give it a try.
All posts by Franck Pachot
I was looking at twitter analytics showing my top tweets in November and that puzzled me because tweets with the most ‘impressions’ and ‘engagments’ are related to events that had low audience in real. Any comment is welcome as it can help to understand why some events have low audience.
By default, In-Memory Column Store population is done in background, asynchronously. There are two hidden parameters that can change this behaviour, let’s see how it works.
Today every DBA should have a lab on his laptop. This is where I reproduce most of cases before opening a SR, or to investigate something, to demo, to learn new features, or to prepare an OCM exam. I’ve a few basic VirtualBox VM with single instance databases (11g and 12c, SE and EE, CDB and non-CDB, etc). I’ve the RacAttack environement with a 3 nodes RAC in 12c on OEL7. But in order to…
It’s next week at #DOAG2015 Interested in a deep dive of logical replication? Let’s try it. The best way to learn is to try it and this is the idea of #RepAttack where you can quickly install a replication configuration on your laptop, using VirtualBox, Oracle XE, and Dbvisit replicate trial version.
This 12c ‘wrong results’ issue is thoroughly described by Mike Dietrich (https://blogs.oracle.com/UPGRADE/entry/switch_off_rowsets_enabled_in) and I’ve nothing to add. This blog post is there to be used as a reference for the comment in the following recommendation that we give to our 12c customers: alter system set “_rowsets_enabled”=false comment=’see http://blog.dbi-services.com/_rowsets_enabled’ scope=both; Our best practice is to document any parameter that is set as a workaround so that it can be revert back when not needed anymore.
When you want to minimize the backup or restore duration, you can parallelize RMAN operations by allocating multiple channels. If you are in cluster, you can open channels from several nodes. Let’s see why, how, and a strange issue: need to set cell_offload_processing=false even if not on Exadata.
I’ve tested a little thing for a customer, and as usual I spool the result into a blog post in case it helps others. Not all replication software – at least in their current version – can manage both different target structure (which is often the main reason for logical replication) and keep up with new DDL on the source (which you can’t avoid – applications evolves). Let’s see how smart is Dbvisit replication with…
Remember my first try of Oracle cloud when Larry Ellison announced the Cloud in june? This week at OOW15 Larry Ellison announced that IBM is not a competitor anymore for them, then I checked IBM Cloud: IBM Bluemix offers IaaS, PaaS and SaaS. As I did in my first trial for Oracle, I’m testing the simplest DB2 ‘SQL Database service’.