Infrastructure at your Service

 
Middleware Team

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

By | Application integration & Middleware | No Comments

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”. This attribute contains the user name who has checked-out the document. In the following picture, you can see the search result with the wrong icon, whereas in the “Version” window, the checked-out icon appears for the…

Read More
Franck Pachot

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

By | Oracle | 9 Comments

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$ but here is a script that shows the calculated ones as well. With no system statistics or NOWORKLOAD the values of IOSEEKTIM (latency in ms) and IOTFRSPEED (transfer in bytes/ms) are set and the SREADTIM (time…

Read More
Franck Pachot

How to measure Oracle index fragmentation

By | Database management, Oracle | 9 Comments

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 always well understood: how index space is managed, block splits, fragmentation, coalesce and rebuilds. Kyle Hailey has made a video of it available here. For me, it is the occasion to share the script I use to see…

Read More
Morgan Patou

Alfresco Summit 2014 – Conferences, Day 2 – Best Practices & Monitoring

By | Application integration & Middleware | No Comments

As I said in my last blog, the Alfresco Summit 2014 took place in London from October 7 to 9. So yeah, unfortunately yesterday was the last day of this amazing event. It’s the first time I had the chance to participate in an Alfresco Summit but I’m quite sure it will not be the last! I can’t tell what moment I preferred during this event because the Keynote (presentation of Alfresco One 5.0) was very…

Read More
Stephane Biehler

Documentum upgrade project: ADTS local user or domain user?

By | Application integration & Middleware | No Comments

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 have one user for several ADTS installations with less AD management. Or you may want to opt for local users to separate the installations, but you will have to manage all users independently. In fact,…

Read More
GĂ©rard Wisson

Documentum upgrade project – from FAST to xPlore

By | Application integration & Middleware | No Comments

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 full repository would be indexed by Monday morning. Since we used a clone of production to validate and test our upgrade process, functions, and performance, we decided to prepare the production fulltext servers by using…

Read More
Stéphane Haby

SQL Server 2014 Tips: Create indexes directly via CREATE TABLE

By | Application integration & Middleware | 2 Comments

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 msdn website, we can see a new section in the “CREATE TABLE” code:   We can directly create an index in the “CREATE TABLE” query. Ok, then let’s go! In my example, I create a diver table with…

Read More
Morgan Patou

Alfresco Summit 2014 – Conferences, Day 1 – Status & New version!

By | Application integration & Middleware | No Comments

Today, I have the chance to be in London for the amazing Alfresco Summit 2014 (7-9 October 2014)! Two weeks ago, the Alfresco Summit took place in San Francisco but unfortunately I wasn’t available at that time. This year, the Alfresco Summit in London is a three day event: the first day is, as often, a training day with a complete day course and the two other days are composed of conferences (General, Business, Technical…

Read More
Franck Pachot

OOW14 Day 5 – not only Oracle OpenWorld

By | Database management, Oracle | No Comments

By Franck Pachot . Oracle’s OpenWorld has ended. It was the fist time I attended this great event and it really is a “great” event: 60000 attendees from 145 countries 500 partners or customers in the exhibit hall 400 demos in the DEMOgrounds 2500 sessions This is Howard Street, a four lane avenue transformed as the Oracle Plazza for the event – in the middle of the 100000m2 of exibition halls and conference rooms: Oracle…

Read More
Nicolas Jardot

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

By | Application integration & Middleware | 5 Comments

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 problem without changing the code – thanks to SQL Patch. The faulty statement was part of a daily job that was configured and started from the application during the night. Every night, the statement failed…

Read More
Middleware Team

Java get Class names from package String in classpath

By | Application integration & Middleware | 2 Comments

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 needed to find out every Class and Sub-Classes inside a package, thus reparteed within several Jars. Internet has lots of solution, but it remains complicated for everybody to reach this goal. After googleing, I found a link…

Read More
Franck Pachot

OOW14 Day 4 – Internals of the 12c Multitenant Architecture by Vit Spinka

By | Database management, Oracle | No Comments

By Franck Pachot . This is the session I preferred at Oracle Open World. Well, I’m writing that before going to @ludodba one and I’m sure I’ll have then two preferred sessions… So Vit Spinka has presented the internals of the new multitenant architecture. It’s always good to play with some internals things. Not only for the geeky fun of it but also because it helps understand how it work and address issues later. I had…

Read More