Infrastructure at your Service

 
Franck Pachot

Oracle cloud control / SQL Details / Statistics

By | Database management, Oracle | No Comments

By Franck Pachot . A question that I had several times: in Enterprise Manager, in the screen about one SQL statement, the ‘statistics’ tab shows the number of executions, elapsed time, etc. Question is: which time window does it cover? There is a one hour chart above, and two timestamps displayed as ‘First Load Time’ and ‘Last load Time’, and we don’t know which one is related with the execution statistics numbers. I’ll explain it…

Read More
Oracle Team

Oracle Grid Infrastructure: fixing the PRVG-10122 error during installation

By | Database management | 2 Comments

Making errors is human and when you configure a new Oracle Grid Infrastructure environment (especially one with a large number of nodes), mistakes can happen when configuring ASMLIB on all nodes. If you get an error looking like”PRVG-10122 : ASMLib configuration…does not match with cluster nodes”, there is a simple solution to fix it. When you are installing Grid Infrastructure, the following error can occor in cluvfy output or directly in the pre-requisites check step…

Read More
Microsoft Team

SQL Server & memory leak: Are you sure?

By | Database management | 2 Comments

I have recently come across an issue with one of my customer that told me that their SQL Server 2008 R2 instance had a memory leak. These are strong words! The server has 64 GB of RAM and the concerned SQL Server instance is limited to 54 GB according to the max server memory (GB) server option. However, he noticed that SQL Server used 60 GB of memory which did not correspond to the configured…

Read More
Franck Pachot

Oracle: an unexpected lock behavior with rollback

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . Here is an odd Oracle behavior I observed when a transaction that acquired a lock is rolled back. Note that this is related to a specific combination of locks that should not be encountered in production. So it’s not a bug. Just something unexpected.   First session In my first session I lock the DEPT table in share mode (RS) 20:56:56 SQL1> lock table dept in row share mode; Table(s) Locked….

Read More
Stephane Biehler

Documentum Multiple ADTS: Ratio of rendition creations between instances (Part 1)

By | Application integration & Middleware | One Comment

I recently realized there are very few information about multiple ADTS instances installation and management. And we have a customer which has two ADTS running for one docbase. I therefore decided to write a couple of blog posts on “Multiple ADTS”, since it is likely to be helpful for someone in the same situation.   Rendition processing & ADTS instance This first blog post will tell you how to find out which rendition has been…

Read More
Franck Pachot

From 8.0 extended rowid to 12c pluggable db: Why Oracle Database is still a great software

By | Database management, Oracle | 4 Comments

By Franck Pachot . Do you know why Oracle Database is a leader in the database market since 30 years? Do you know any other software that is still the leading solution after decades? I think that it is because Oracle has been a good software from the get-go. Many early decisions in the software architecture have revealed themselves later to be the right decision. Several decisions, such as the C language that made it…

Read More
Stéphane Haby

Les journĂ©es SQL Server 2014 – un event qui devrait vous intĂ©resser!

By | Technology Survey | No Comments

Comme vous le savez peut-ĂŞtre dĂ©jĂ , le plus grand Ă©vĂ©nement SQL Server francophone arrive bientĂ´t. Les journĂ©es SQL Server 2014, organisĂ©es par le GUSS, (Groupement des Utilisateurs SQL Server) sont Ă  Paris les 1 et 2 dĂ©cembre 2014. dbi services y est aussi – et vous?   Les journĂ©es SQL Server 2014 Voici le site de l’event: http://guss.pro/2014/12/01/journees-sql-server-2014/ Les 2 jours traitent aussi bien de l’administration, du dĂ©veloppement que de la BI SQL Server 2014….

Read More
Microsoft Team

SQL Server failover cluster, VSphere, & SCSI-3 reservation nightmares

By | Operation systems | No Comments

When I have to install a virtualized SQL Server FCI at a customer place as an SQL Server consultant, the virtualized environment usally is ready. I guess this is the same for most part of the database consulting people. Since we therefore lack practice, I have to admit that we do not always know the good configuration settings to apply to the virtualized layer in order to correctly run our SQL Server FCI architecture. A…

Read More
Middleware Team

Documentum upgrade project: from D2-Config 3.1 to D2-Config 4.1

By | Application integration & Middleware | No Comments

During a migration from D2-Config 3.0 to D2-Config 4.1, we have encountered 2 issues. In order to have a clean installation and the insurance of being able to backup the configuration, we have decided to perform a full config export on D2-Config 3.0 and a full import with a configuration reset to D2-Config 4.1. 1. Configuration export The first issue we experienced was regarding docapps existing in the repository. As you can see in following…

Read More
Franck Pachot

What about ALTER INDEX … SHRINK SPACE ?

By | Database management, Oracle | No Comments

By Franck Pachot . I have recently published a script to check index fragmentation. But then, do you COALESCE or REBUILD? Well, there also is another option: ALTER INDEX SHRINK SPACE. Let’s compare all those index defragmentation operations. Fragmented index I have an index created when the table had 1 million rows. Then, I deleted 90% of the rows. Here is the index state from: dbms_space.space_usage index_stats after an analyze index validate structure my index…

Read More
Stéphane Haby

Windows 10: The new features

By | Technology Survey | No Comments

First, it should have been Windows 9, but finally the new Microsoft operating system is named Windows 10! In the same way as for my blog post on Windows 8, I have decided to write a few words about the new features of Windows 10. Why 10? It’s a good question and I have read many articles about it. First, I read that Windows 9 is the Windows 8.1 version, then its logic to have…

Read More
Middleware Team

Documentum upgrade project: Configuring NTLM SSO for D2 3.1 SP1

By | Application integration & Middleware | No Comments

The Documentum D2 3.1 SP1 release is kind of a mix between D2 4.1 APIs (using D2FS in backend) and D2 3.1 front-end. It needs SSO to be fully implemented and the configuration has to be applied for 3.1 as well as for D2FS. For D2FS, the same configuration applies whether you are using the NT Lan Manager (NTLM) or Kerberos authentication. If you want to implement Kerberos Single Sign On instead of NTLM, have…

Read More