Database Administration & Monitoring

Database Diagram using SQL Developer

By Mouhamadou Diaw Last Day a client asked me if I can generate a relational diagram for an oracle schema. He was just preparing a migration and wanted to see how tables are organized in the schema. In this(…)

Running SLOB on Exadata Express Cloud Service

By Franck Pachot . The Exadata Express Cloud Service is a managed PDBaaS: Oracle is the system admin and the CDB database administrator, you are the PDB administrator. You connect with a local user, PDB_ADMIN, which is no SYSDBA privilege(…)

Can I do it with PostgreSQL? – 9 – Temporary tables

It has been quite a while since the last posts in this series, so here is what we looked at until now: Can I do it with PostgreSQL? – 1 – Restore points Can(…)

Amazon AWS instances and Oracle database performance

By Franck Pachot . When you run Oracle Database on Amazon AWS you Bring Your Own Licenses depending on the number of virtual cores (which are the number of cores allocated to your vCPUs). Behind the instance types, you have(…)

Introducing high-availability and multi-subnet scenarios with SQL Server on Linux

On my first blog about SQL Server on Linux, I introduced the new high availability feature which concerns only SQL Server failover(…)

Oracle Core factor and Oracle or non-Oracle Cloud

By Franck Pachot . Oracle Database licensing can be based on two metrics: Processor or Named User Plus (NUP). NUP also necessitate to count the processors because there is a minimum number of NUP per processor. Then it is very(…)

Temporal tables with PostgreSQL

By Mouhamadou Diaw In this blog we are going to talk about a nice extension in PostgreSQL: temporal_tables. This extension provides support for temporal tables. What is a temporal table? Just a table that tracks the period(…)

Part 2 – vagrant up – get your Oracle infrastructure up an running

Last week in the first part of this blog we have seen a short introduction how to setup an Oracle Infrastructure with Vagrant and Ansible. Remember(…)

Oracle 12cR2 – RMAN cold backup with TAG’s

By William Sescu I am planning to backup my 12R2 container database, because a huge application change is coming up, and I want to be sure that I have a good RMAN backup beforehand. For that particular DB, I(…)

Exadata Express Cloud Service: PDB_ADMIN privileges

By Franck Pachot . I usually explain that the main point about Multitenant Architecture is the separation of roles between a system DBA who manages the container, and is responsible for its availability, and application DBA who owns all the(…)