Oracle

Interested in a deep dive of logical replication?

By Franck Pachot . 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(…)

set “_rowsets_enabled”=false

By Franck Pachot . 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(…)

AWR when ASH CPU >> DB CPU

By Franck Pachot . I'll present How to read an AWR report next month at UKOUG TECH15 and the first recommendation after checking Average Active Sessions is to verify that we are not in a CPU starvation situation. Here is(…)

RMAN channels in RAC

By Franck Pachot . 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(…)

Dbvisit replicate allows DDL replication even when source and destination have different structure

By Franck Pachot . 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 -(…)

IBM Bluemix Database Cloud Service – My first trial

By Franck Pachot . 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(…)

DBA, turkeys and NoSQL hype

By Franck Pachot . We (DBAs) look at this NoSQL hype with a large smile. We know how powerful are SQL databases and we can't imagine processing data seriously without it. And the technologies that come with NoSQL brings back(…)

SQL> alter database switchover to …

By Franck Pachot . In 12c the manual switchover to physical standby requires only one command (ALTER DATABASE SWITCHOVER) instead of two (ALTER DATABASE COMMIT TO SWITCHOVER on each database). We usually recommend to use the broker and I(…)

Oracle Cloud Service – my first outage

By Franck Pachot . We experienced the first planned outage this week-end, so let's see how it is notified and what happens.

You are in Standard Edition, when to worry?

By Franck Pachot . A previous blog post explaining what happens for those in 'Standard Edition One' had a "don't worry" in the title because you can upgrade to SE2 with minimal additional cost - except(…)