All articles

Documentum story – Documentum JMS Log Configuration

The aim of this blog is to provide you a way to configure the JMS Logs in order to align all applications logging with date information, log rotation and retention. Some changes have to be done on the jboss container(…)

SQL Server 2016 – R Services Tips: How to find installed packages using T-SQL?

If you have restricted access to the server and you do not know if your packages are installed on the SQL Server with the R Services, you have the possibility to do it by T-SQL. The R command/function to(…)

SQL Server 2016: New useful function STRING_SPLIT()

Now, in the latest version of SQL Server, you have one of the most expected function as well as for developers as for administrators, splitting a string natively in T-SQL: STRING_SPLIT(<character expression>,<separator>) This function has 2 parameters: The(…)

Oracle 12c – Difference between ‘%F’ #default and ‘%F’

By William Sescu Do you see any differences between these two RMAN SHOW commands? RMAN> SHOW CONTROLFILE AUTOBACKUP FORMAT; RMAN configuration parameters for database with db_unique_name OCM121 are: CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default(…)

Oracle 12c – Automatic Control File Backups

By William Sescu By default, automatic control file backups are disabled (even with 12c), maybe for performance reasons. RMAN> SHOW CONTROLFILE AUTOBACKUP; RMAN configuration parameters for database with db_unique_name OCM121 are: CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default And also good(…)

Oracle 12c – When the RMAN Dummy Instance does not start up …

By William Sescu Not too often, but sometimes you might run into a situation when you lose everything, your DB Files, your Controlfiles and even your spfile. In situations like that, you need to restore first your spfile, then your(…)

Documentum story – SSL Password for the JKS of the DSearch & IndexAgent (xPlore)

In a previous blog (click here), I described how to setup the DSearch and IndexAgent(s) in HTTPS using the Groovy script provided by EMC in newer(…)

Oracle 12c – When did my row change?

By William Sescu My good old DEPT table always had 4 rows with 4 different departments. However, I have noticed that a new row was inserted into the DEPT table and the row 50 popped up, and I would like to(…)

12c GTT private statistics and cursor invalidation

By Franck Pachot . Short summary of this post is that rolling invalidation do not occur when you gather statistics on Global Temporary Tables in 12c that have session statistic scope (which is the default) and this may cause too(…)

Documentum story – Status of IndexAgent not visible in HTTPS (xPlore)

In one of our project, we were using CS 7.2 P02 (upgraded later with P05) in correlation with xPlore 1.5 P02. With these versions, we wanted to setup the IndexAgents in HTTPS to have a completely secured environment. We choose(…)