Oracle

18c: some optimization about redo size

By Franck Pachot . Some years ago, at the time of 12.1 release, I published in the SOUG newsletter some tests to show the amount of redo generated by different operations on a 10000 rows(…)

Event Sourcing: CQN is not a replacement for CDC

By Franck Pachot . We are in an era where software architects want to stream the transactions out of the database and distribute them, as events, to multiple microservices. Don't ask why, but that's the trend: store inconsistent eventually consistent(…)

Statspack installation scripts

By Franck Pachot . When Diagnostic Pack is disabled, either because you don't have Diagnostic Pack or you are in Standard Edition, I highly recommend to install Statspack. When you will need it, to investigate on an issue that occured(…)

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(…)

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(…)

Remote syslog from Linux and Solaris

By Franck Pachot . Auditing operations with Oracle Database is very easy. The default configuration, where SYSDBA operations go to 'audit_file_dest' (the 'adump' directory) and other operations go to the database may be sufficient to log what is done but(…)

ADWC new OCI interface

By Franck Pachot . A few things have changed about the Autonomous Data Warehouse Cloud service recently. And I've found the communication not so clear, so here is a short post about what I had to do to start the(…)