All articles

CBO parse time – matching time with transformation

By Franck Pachot . By a strange coincidence, I've encountered several cases of long parse time recently. That was the occasion to give a closer look at a CBO trace enhancement that came with April 2016 PSU: Bug 16923858 Diagnostic(…)

Exadata Express Cloud Service: MAX_PDB_STORAGE

By Franck Pachot . The separation of roles between system DBA and application DBA is the way to go for agile development and the PDBaaS managed service is an excellent way to play with this concept: You are PDB administrator(…)

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

Oracle 12c – How to Prevent License Violation with Active Data Guard

By William Sescu There are some articles floating around how to prevent a license violation with Active Data Guard. Some of them related to an underscore parameter “_query_on_physical” and some of them related to a startup trigger. Both of them(…)

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