All articles

JAN18: Database 11gR2 PSU, 12cR1 ProactiveBP, 12cR2 RU

By Franck Pachot . If you want to apply the latest patches (and you should), you can go to the My Oracle Support Recommended Patch Advisor. But sometimes it is not up-todate. For example, for 12.1.0.2 only the PSU is(…)

Multitenant, PDB, ‘save state’, services and standby databases

By Franck Pachot . Creating - and using - your own services has always been the recommendation. You can connect to a database without a service name, though the instance SID, but this is not what you should do. Each(…)

Introducing SQL Server on Docker Swarm orchestration

SQL Server 2017 is available on multiple platforms: Windows, Linux and Docker. The latter provides containerization features with no lengthy setup and special prerequisites before running your SQL Server databases which are probably the key success of adoption for developers.

Migrate Windows VM with more than 4 Disks from VMware to OVM

Suppose you got an OVA image created on VMware and the VM contains more than 4 Disks and you have to migrate this machine from VMware to OVM. As first step you import the OVA into the OVM in(…)

Result Cache: when *not* to use it

By Franck Pachot . I encountered recently a case where result cache was incorrectly used, leading to high contention when the application encountered a peak of load. It was not a surprise when I've seen that the function was called(…)

Testing Oracle SQL online

By Franck Pachot . Want to test some DDL, a query, check an execution plan? You need only a browser. And you can copy-paste, or simply link, your test-case in a forum, a tweet, an e-mail, a tweet. Here is(…)

Explain Plan format

By Franck Pachot . The DBMS_XPLAN format accepts a lot of options, which are not all documented. Here is a small recap of available information. The minimum that is displayed is the Plan Line Id, the Operation, and the Object(…)

Unplug an Encrypted PDB (ORA-46680: master keys of the container database must be exported)

By Franck Pachot . In the Oracle Database Cloud DBaaS you provision a multitenant database where tablespaces are encrypted. This means that when you unplug/plug the pluggable databases, you also need to export /import the encryption keys. You cannot just(…)

SQL Server on Linux and logging

On Windows world, SQL Server logs information both into the SQL Server error log and the Application log. Both automatically timestamp all recorded events. Unlike the SQL Server error log, the Windows application log provides an overall picture of events(…)

Alfresco DevCon 2018 – Day 2 – Big files, Solr Sharding and Minecraft, again!

Today is the second day of the Alfresco DevCon 2018 and therefore yes, it is already over, unfortunately. In this blog, I will be continuing my previous(…)