Oracle

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(…)

11.2.0.4 support? Don’t worry until 2017

By Franck Pachot . Customers reluctant to go to 12c before 12.2, in addition to Standard Edition contract changes when going to 12c, has lead to lot of upgrades to 11.2.0.4 but what about support? Don't worry. It's supported for(…)

Mapping In-memory CU to values: IMCU pruning

By Franck Pachot . In the previous post we have seen how In-Memory Compression Unit map to the physical persistent storage - table extents. Let's see now how they are(…)