All articles

Exception from executeScript in Alfresco Share

I didn’t have the opportunity to post a new entry about Alfresco in this blog for a long time now, so I will fix this! In this blog entry, I will talk about a bug I encountered a few(…)

Never gather WORKLOAD stats on Exadata…

By Franck Pachot . For Exadata, oracle has introduced an ‘EXADATA’ mode which sets a high transfer rate (with IOTFRSPEED as in NOWORKLOAD statistics) and set a MBRC (as in WORKLOAD statistics). Those values are set rather than gathered(…)

Oracle multitenant dictionary: rowcache

By Franck Pachot . I’ve not finished with my investigation on 12c multitenant dictionary. Here, I’m checking how metadata links are managed by the dictionary cache (aka rowcache). As I did previously, I’ll create a metadata link function(…)

Vsphere 6.0 improvements for Windows Failover Clusters

A couple of days ago, VMWare announced vSphere 6.0. I guess many of our customers have been waiting for this new release and probably I will see in the next few months this new version rolled out on the(…)

IOUG Collaborate #C15LV

By Franck Pachot . The IOUG – Independant Oracle User Group – has a great event each year: the COLLABORATE. This year it’s in April 12-16, 2015 at The Mandalay Bay Resort & Casino in Las Vegas. I’ll be(…)

SQL Server: Online index rebuild & minimally logged operations

A couple of days ago, I encountered an interesting case with a customer concerning a rebuild index operation on a datawarehouse environment. Let me introduce the situation: a “usual DBA day” with an almost usual error message found in your(…)

Birst: an attractive “all-in-one” Business Intelligence solution

The review of the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms has revealed a new challenger that could become one of the leader of this market: Birst – an interesting “all-in-one” BI solution.

Documentum Multiple ADTS – Ratio of rendition creations between instances (Part 2)

This is the second part of my previous blog concerning rendition creation ratio between two ADTS servers. In this part I will talk about another way of getting this ratio. In addition this one doesn’t require to enable auditing and(…)

Flush one SQL statement to hard parse it again

By Franck Pachot . If you want a statement to be hard parsed on its next execution, you can flush the shared pool, but you don’t want all the cursors to be hard parsed. Here is how to flush(…)

Stay with non-CDB or go to CDB?

By Franck Pachot . This is a question that starts to be raised quite frequently. Oracle released the multitenant architecture 1.5 year ago. And now says that the previous architecture – known as non-CDB – is deprecated. What does(…)