Database Administration & Monitoring

OUD 11.1.2.3 – Patch 25840309: OUD BUNDLE PATCH 11.1.2.3.170718

By William Sescu A new OUD bundle patch was release at the 18th of July 2017, and this gives me the opportunity to show how fast an OUD can be patched, if configured correctly. In case you have an OUD(…)

Recommended DB Parameters on the Oracle Database Appliance (ODA)

When creating a DB on the ODA using # oakcli create database -db <db-name> a template is used to set a couple of DB parameters like e.g. _datafile_write_errors_crash_instance=FALSE _db_writer_coalesce_area_size=16777216 _disable_interface_checking=TRUE _ENABLE_NUMA_SUPPORT=FALSE(…)

Can I do it with PostgreSQL? – 16 – DDL triggers

A question I received recently from a customer: Oracle gives you the possibility to create DDL triggers. DDL triggers fire (as the name implies) when DDL events occur. Can we do that in PostgreSQL? Yes, this feature(…)

What are typed tables in PostgreSQL?

While reading the PostgreSQL documentation for "CREATE TABLE" I came across this: "OF type_name: Creates a typed table, which takes its structure from the specified composite type (name optionally schema-qualified). A typed table is tied to its(…)

Did you ever wonder what PostgreSQL is executing in the background when you use the psql shortcuts?

When you work with PostgreSQL you are probably using psql and when you use psql you are probably using one or more of the shortcuts psql is providing. These shortcuts provide a quick and convenient way to(…)

Azure Compare Total Cost of Ownership (TCO) with comparable Azure deployment

Microsoft Azure allows you to quickly deploy infrastructures and services to meet all of your business needs. You can run Windows and Linux based applications in 36 Azure datacenter regions, delivered with enterprise grade SLAs. Microsoft Azure offer you(…)

Can I do it with PostgreSQL? – 15 – invisible indexes

It has been quite a while since the last post in this series. Today we'll look at what you know from Oracle as: Invisible indexes. In case you wonder what they might be useful for: Imagine you(…)

Migration to SQL Server 2016 with deprecated data types and Full-Text

A few weeks ago, I prepared a migration from SQL Server 2008 to SQL server 2016, I came across a case with deprecated data types and a Full-Text activated on these columns. To simulate this scenario, I downloaded and(…)

SQL Server 2016: patching CU with R Services

As a good DBA, I begin to be up to date with all Cumulative Update (CU) by my customers. It is the first time that I run an update for SQL Server 2016 with the CU 3. I(…)

Grid Infrastructure 11.2.0.3 PSU: My Opatch version check is failing

Mouhamadou Diaw Last day I was configuring grid infrastructure 11.2.0.3 for a standlone server. After the installation, I decided to apply the Patch Set Update 11.2.0.3.7 (Includes Database PSU 11.2.0.3.7) – 16742216 In the documentation it is marked(…)