With 9.7 DB2 LUW version, IBM makes a nod to all Oracle DBAs, much more numerous in the DB2 market.

For this reason, 9.7 version has introduced Oracle compatibility modes that let you perform tasks in DB2 with the ease and knowledge that all Oracle DBAs have. However, it is important to know the terminology's translation between Oracle and DB2 if you intend to get into the DB2 world.

In this first article, I relate a number of items from which this introduction is simple and can be read DB2 documentation easily, including general terminology, updates, utilities, and views.

Since the release 1 of Oracle 11g, Oracle provides the ability to encrypt tablespaces in full, to protect sensitive data inside and accessible from the OS. That is, the objective of this new functionality is not to protect sensitive data of users of the database, but to protect the information of the tablespace datafiles.

To explain the usefulness of this feature, it is best to explain situations in which our data without this functionality would be vulnerable. For example, in the case file of a physical backup of a database tablespace were to wrong hands, could see some data "clear" without problems. For example, a single edition of tablespace (or a simple "cat") containing the Employees table, we show clear varchar2 fields can extract sensitive data (you do not believe, try it!).

Anyone who usually look at AWR performance reports to analyze Oracle performance problems, often have their own reading process and approach to all data that shows this report, but I always missed a tool that make easier reading all data.

In Oracle 11g release 2, Oracle introduced a new product Oracle Real Application Clusters One Node (Oracle RAC One Node)

This product is an Oracle RAC' s instance but executed in one single node. May be run on different physical servers, not only one (this is common) but a database instance is running only on the same node  simultaneously  (* but we'll see later that this is not completely true).

Todo aquel, especialmente DBA's de Oracle, que suele mirar informes de rendimiento AWR en Oracle para analizar problemas de rendimiento, suele tener su propio procedimiento de lectura y aproximación a todos los datos que nos muestra este informe, pero como DBA siempre he echado en falta alguna herramienta que te facilite la lectura de todos los datos. “AWR Formatter” desarrollado por el Oracle DBA Tyler Muth permite facilitar esta lectura.

En la release 2 de Oracle 11g, se introduce un nuevo producto Oracle Real Application Clusters One Node (Oracle RAC One Node).

La definición rápida del producto seria: es una instancia de Oracle RAC pero ejecutado en 1 único nodo. No es que sea una única máquina física, puede estar corriendo en diversos servidores físicos (de hecho, es lo habitual) sino que una instancia de Base de Datos está ejecutándose únicamente en 1 nodo al mismo tiempo (* aunque ya veremos que está afirmación no es del todo cierta).

Lo más fácil es ver un esquema para entenderlo a la perfección:

En este esquema, tenemos 3 servidores físicos que contienen un total de 5 instancias Oracle ejecutándose con Oracle RAC One Node.  Cada nodo tiene un S.O., es decir, no son máquinas virtuales distintas.

Cuáles son sus ventajas más destacables: