All articles

Oracle IOT: when to use Index Organized Tables

By Franck Pachot . When can we use IOT? That’s a question I had when giving recently the Oracle DBA essentials workshop. the DBA Essential is very dense and there is only half a day about performance. We(…)

SQL Server: Forced failover with AlwaysOn & Availability Groups

During a workshop at one of my customer about the implementation of SQL Server AlwaysOn and availability groups, I had an interesting discussion. It was about asynchronous replication between 2 replicas and the effect of the forced failover operation(…)

Documentum upgrade project: Wrong icons in D2 search results with xPlore

After migrating from “Fast” to “xPlore” Documentum full-text search engine, our team discovered wrong icons in D2 search results. Documents in checked-out state continued to be displayed with the normal icon, even if xPlore indexed attribute value for “r_lock_owner”.

Oracle system statistics: Display AUX_STATS$ with calculated values and formulas

By Franck Pachot . System statistics can be gathered in NOWORKLOAD or WORKLOAD mode. Different values will be set depending on that and the others will be calculated – derived from them. We can see defined values from SYS.AUX_STATS$(…)

How to measure Oracle index fragmentation

By Franck Pachot . At Oracle Open World 2014, or rather the Oaktable World, Chris Antognini has presented ‘Indexes: Structure, Splits and Free Space Management Internals’. It’s not something new, but it’s still something that is not(…)

Documentum upgrade project: ADTS local user or domain user?

ADTS local user or domain user: Which user should I choose as the installation owner? This question is important if you are installing a new Advanced Document Transformation Services (ADTS).  You can opt for a domain user in order to(…)

Documentum upgrade project – from FAST to xPlore

We planned to do our full production upgrade in a weekend – and one part was the replacement of FAST by xPlore. As we had to index more than 10 millions objects, we had to find a solution where the(…)

SQL Server 2014 Tips: Create indexes directly via CREATE TABLE

This week, I discovered a new enhancement which is not hidden but not really visible in SQL Server 2014. Among Hekaton and other new features in SQL Server 2014, a little option appears in table creation.8-O On the(…)

SQL Patch: Another way to change the plan without changing the code

Recently, at a customer site, I faced a performance issue. However, as often the statement is embedded in the application so it’s not possible to rewrite the query. In this blog post, we’ll change the execution plan to solve the(…)

Java get Class names from package String in classpath

As a Java developer you probably used to know about reflexion. However, in order to keep your software architecture flexible, some functionalities are sometimes not provided out of the box by the JVM. In my particular case, I(…)