Database management, Oracle Variations on 1M rows insert (4): IN MEMORY 18.05.2015 by Oracle Team By Franck Pachot . Oracle In-Memory option is for reporting. Oracle has chosen an hybrid approach: maintain the In-Memory Column Store in addition of the buffer cache. Dont’ forget our In-Memory event, but for the moment, let’s try(…)
Database management, Oracle Matching SQL Plan Directives and queries using it 18.05.2015 by Oracle Team By Franck Pachot . This is another blog post I’m writing while reviewing the presentation I’m doing next week forSOUG and next month for DOAG. You have SQL Plan Directives used by several queries that have same(…)
Database management, Oracle Matching SQL Plan Directives and extended stats 18.05.2015 by Oracle Team By Franck Pachot . This year is the year of migration to 12c. Each Oracle version had its CBO feature that make it challenging. The most famous was the bind variable peeking in 9iR2. Cardinality feedback in 11g also(…)
Application integration & Middleware Yammer blow in SharePoint ! 18.05.2015 by Microsoft Team Communication … Collaboration! Lost in Communication … Collaboration? Which SOLUTION? Once upon a Time… Microsoft created SharePoint and Yammer! SharePoint What is SharePoint? CMS? It’s “something to stock documents”? It’s almost Documentum? In real: SharePoint could(…)
Application integration & Middleware Concrete5 CMS 18.05.2015 by Microsoft Team Today, a lot of CMS are existing, WordPress, Joomla, Magento, and others, in this blog I will share my experience Concrete5 through a web agency specialized based in Geneva: 8 Ways Media What Concrete5? Not only a(…)
Application integration & Middleware EMC World 2015 – Day 3 at Momentum 18.05.2015 by Gérard Wisson In this post I would like to relay some advices around the upgrade to Documentum 7.2 I have got in the session from Patrick Walsh about “What’s New, what’s Next: EMC Documentum Platform”. With Documentum 7.2 the processes for the(…)
Application integration & Middleware EMC World Las Vegas – Momentum 2015 third day D2 news 18.05.2015 by Middleware Team This was a more day of networking with EMC partner contact and third party software editors. On the other side I attended a session about D2 news and what is comming next. EMC divided D2 enhancements by 3 main major(…)
Development & Performance Variations on 1M insert (2): write commit 18.05.2015 by Microsoft Team In this blog post, I will try to do the same than my colleagues about Oracle and for PostgreSQL. As a reminder, we’ve seen in my previous blog post that SQL Server is designed(…)
Database management, Oracle Variations on 1M rows insert (4): APPEND_VALUES 18.05.2015 by Oracle Team By Franck Pachot . In the first variation I did a bulk insert with the PL/SQL FORALL statement. A comment suggests to add the APPEND_VALUES hint that appeared in 11gR2. APPEND_VALUES hint does the same than APPEND but(…)
Development & Performance Variations on 1M rows insert (1): bulk insert 18.05.2015 by Microsoft Team I think you already have read the interesting series of blog posts of my colleagues Franck and Daniel about inserting on 1 million rows for Oracle and PostGreSQL. So it’s time to write the first of the same series(…)