All articles

Variations on 1M rows insert (5): using ‘perf’

By Franck Pachot . In previous post I explained that I’ve observed a 2x CPU usage when running my insert test case in 11.2.0.4 vs. 11.2.0.2 I discussed that with @martinberx @OracleSK @TanelPoder @xtner @Ycolin @fritshoogland @lleturgez @LucaCanaliDB on(…)

Variations on 1M rows insert (4): IN MEMORY

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

Matching SQL Plan Directives and queries using it

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

Matching SQL Plan Directives and extended stats

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

Yammer blow in SharePoint !

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

Concrete5 CMS

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

EMC World 2015 – Day 3 at Momentum

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

EMC World Las Vegas – Momentum 2015 third day D2 news

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

Variations on 1M insert (2): write commit

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

Variations on 1M rows insert (4): APPEND_VALUES

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