All articles

DataGuard and Transparent Data Encryption

By Mouhamadou Diaw Setting up a DatagGard environment for a database with Transparent Data Encryption requires some tasks concerning the encryption keys. Otherwise the steps are the same than for an environment without TDE. In this blog we will(…)

PGIO, PG_STAT_ACTIVITY and PG_STAT_STATEMENTS

By Franck Pachot . For an Oracle DBA, we are used to join active sessions (from V$SESSION where status='ACTIVE) with active statements (from V$SQL where users_executing>0) on the SQL_ID. V$ACTIVE_SESSION_HISTORY also displays the TOP_LEVEL_SQL_ID to get the entrypoint of the(…)

Lighty for PostgreSQL

By Franck Pachot . If you follow this blog, you should know how I like Orachrome Lighty for Oracle, for its efficiency to monitor database performance statistics. Today Orachrome released the beta version of Lighty for Postgres:(…)

Oracle Virtual Private Database

By Mouhamadou Diaw Oracle Virtual Private Database (VPD) enables you to dynamically add a WHERE clause in any SQL statement that a user executes. The WHERE clause filters the data the user is allowed to access, based on the identity(…)

Kernel panic – not syncing: Out of memory and no killable processes

By Franck Pachot . This is a quick post to give a solution (maybe not the best one as this was just quick troubleshooting) if, at boot, you see something like: Trying to allocate 1041 pages for VMLINUZ [Linux=EFI, setup=0x111f,(…)

18c: No Active Data Guard required (and detected) when only CDB$ROOT and PDB$SEED are opened in read-only

By Franck Pachot . When you clone a PDB on the primary CDB, you want that the same is automatically done on the standby ones. Unfortunately, for this operation, the CDB must be opened read-only. In 12.1 even the PDB(…)

Introduction to databases for {Power.Coders} with MySQL

By Franck Pachot . This week I took some days off to do something related to my job but a bit different. I've given a course on Databases and SQL. But not for my usual customers. And not(…)

MySQL 8.0 – Roles are finally there

Roles have been existing on many RDBMS for a long time by now. Starting from version 8.0, this functionality is finally there for MySQL. The most important advantage is to define only once a role that includes a “set(…)

What’s new in EDB EFM 3.1?

Beginning of this month EnterpriseDB announced a new version of its Failover Manager. Version 2.1 introduced controlled switchover operations, version 3.0 brought support for PostgreSQL 10 and now: What's new in version 3.1? It(…)

utl_dbws causes ORA-29532 and bad_record_mac

After installing OJVM patch set update APR-2017 on a 11.2.0.4 database with PSU APR-2017 installed, first call of utl_dbws package was successful, but after a while utl_dbws calls failed always with ORA-29532 and bad_record_mac. All Java objects remained valid.