Database management, Oracle Oracle multitenant dictionary: rowcache 08.02.2015 by Oracle Team 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(…)
Hardware & Storage Vsphere 6.0 improvements for Windows Failover Clusters 04.02.2015 by Microsoft Team 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(…)
Operating systems, Oracle IOUG Collaborate #C15LV 03.02.2015 by Oracle Team 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(…)
Application integration & Middleware SQL Server: Online index rebuild & minimally logged operations 30.01.2015 by Microsoft Team 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(…)
Enterprise content management Birst: an attractive “all-in-one” Business Intelligence solution 29.01.2015 by Alain Lacour 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.
Application integration & Middleware Documentum Multiple ADTS – Ratio of rendition creations between instances (Part 2) 29.01.2015 by Middleware Team 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(…)
Database management, Oracle Flush one SQL statement to hard parse it again 29.01.2015 by Oracle Team 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(…)
Database management, Oracle Stay with non-CDB or go to CDB? 28.01.2015 by Oracle Team 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(…)
Database management, Oracle When to gather workload system statistics? 23.01.2015 by Oracle Team By Franck Pachot . This month we started to give our Oracle Tuning Workshop. And with a new workshop comes new questions. We advise to give to the optimizer the most accurate statsistics that we can have. That(…)
Application integration & Middleware Memory management, OOM issues with SQL Server 2014 In-memory OLTP 22.01.2015 by Microsoft Team Last week I gave a workshop about SQL Server 2014 and the new features. The first day we worked on new In-memory OLTP and different topics such as the new internal storage, the new transaction processing behavior or the(…)