All articles

20c: AWR now stores explain plan predicates

By Franck Pachot . In a previous post https://www.dbi-services.com/blog/awr-dont-store-explain-plan-predicates/ I explained this limitation in gathering filter and access predicates by Statspack and then AWR because of old bugs about reverse parsing of predicates. Oracle listens(…)

SQL Server 2019: Copy files through SQL Server

Three new interesting extended stored procedures comes with SQL Server 2019. I was very interested to discover these new store procedures: Sys.xp_copy_file is to copy a specific files from a folder to another Syntax: exec master.sys.xp_copy_file ‘source folder+file’, ‘destination(…)

How to install MABS (Microsoft Azure Backup Server) and use it to protect on-premise virtual machines

During my last blog-posts I tested the MARS (Microsoft Azure Recovery Service) through Windows Admin Center and how to use Azure Backup to recover files/folders or System State for protected servers. To continue my Azure protection possibilities overview I(…)

Oracle Materialized View Refresh : Fast or Complete ?

In contrary of views, materialized views avoid executing the SQL query for every access by storing the result set of the query. When a master table is modified, the related materialized view becomes stale and a refresh is necessary to(…)

Handle DB-Links after Cloning an Oracle Database

By Clemens Bleile After cloning e.g. a production database into a database for development or testing purposes, the DBA has to make sure that no activities in the cloned database have an impact on data in other production databases. Because(…)

Documentum Upgrade – dm_DataDictionaryPublisher with wrong target server

As part of the same migration & upgrade project I talked about in previous blogs already (corrupt lockbox & duplicate objects), I have seen a strange but consistent behavior in each upgrade(…)

APEX Connect 2020 – Day 1

This year the APEX connect conference goes virtual online, like all other major IT events, due to the pandemic. Unfortunately it spans only over two days with mixed topics around APEX, like JavaScript, PL/SQL and much more. After the welcome(…)

The evolution of MySQL authentication mechanism

The authentication, the first level of security for each IT system, is the stage to verify the user identity through the basic username and password scheme. It is crucial to have a mechanism to protect and secure password storing and(…)

Control-M/EM Job in wait hosts status

Hello everybody, Introduction Today we will try to debug a classic case of schedulers: The wait host status. Context: On monitoring domain, one or more jobs are not submitted to the host then are in blue (wait host) status(…)

The myth of NoSQL (vs. RDBMS) agility: adding attributes

By Franck Pachot . There are good reasons for NoSQL and semi-structured databases. And there are also many mistakes and myths. If people move from RDBMS to NoSQL because of wrong reasons, they will have a bad experience and(…)