Oracle Team

Installing ZFS on OEL7 UEK4 for Docker storage

By Franck Pachot . The Oracle Database is fully supported on Docker according that Linux is Red Hat Enterprise Linux 7 or Oracle Enterprise Linux 7 with Unbreakable Enterprise 4. This is documented in MOS(…)

Google Cloud Spanner – inserting data

By Franck Pachot . In a previous post I've created a Google Cloud Spanner database and inserted a few rows from the GUI. This is definitely not a solution fo many rows and here is a(…)

Control File issues on duplicating with non patched Oracle version.

Introduction : RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server with the same file structure, or(…)

Google Cloud Spanner – no decimal numeric data types

By Franck Pachot . Google Cloud Spanner is a distributed relational database focused on scalability without compromising consistency and integrity. It is available only as a managed service in Google Cloud. Basically, the idea is to keep the scalability advantages(…)

Drilling down the pgSentinel Active Session History

By Franck Pachot . In pgSentinel: the sampling approach for PostgreSQL I mentioned that one of the advantages of the ASH approach is the ability to drill down from an overview of the database activity,(…)

Database Vault : Rules, Rule Sets and Command Rules

By Mouhamadou Diaw In a previous blog I talked about protecting data using Realms. With Database Vault we can also protect our database against some SQL statements. These statements can include SELECT, ALTER SYSTEM, database(…)

pgSentinel: the sampling approach for PostgreSQL

By Franck Pachot . Here is the first test I did with the beta of pgSentinel. This Active Session History sampling is a new approach to Postgres tuning. For people coming from Oracle, this is something(…)

Oracle Database Vault: Realm in a Pluggable Database

By Mouhamadou Diaw Database Vault can also be used in a multitenant environment. In a multitenant environment we must register Oracle Database Vault in the root first, then after in the PDBs. In this blog we will see how(…)

Data Guard: always set db_create_file_dest on the standby

By Franck Pachot . The file name convert parameters are not dynamic and require a restart of the instance. An enhancement request was filled in 2011. I mentioned recently on Twitter that it can be annoying with Active Data Guard(…)

My tmux scripts to script demos

By Franck Pachot . When I did my first demo using tmux, I have written the following blog post to explain it: https://www.dbi-services.com/blog/using-tmux-for-semi-interactive-demos/. Since then I've done all my demos with this technique. My scripts and(…)