Author: Marcos Siqueira

When investigating why an Oracle job is taking a long time to execute, normally the DBA will identify the DML instructions or select queries running longer and different approaches might be used to improve the performance, e.g., create new indexes,…

The idea of this post is to show how to handle errors using SQLCODE function. That function shows the code error for the latest exception when running a PL/SQL code. Here is a small example of code that raises an…

Objective: Upgrade Oracle database from 11.2.0.4 to 12.2.0.1 During the Oracle database upgrade process from 11.2.0.4 to 12.2.0.1 (Standard Edition), running on Windows Server 2012 R2 64bit, the following error was found while executing the dbupgrade script. C:>dbupgrade LOG FILES:…

The column-oriented Vertica Analytics Database Platform was designed to manage large, fast-growing volumes of data and provide very fast query performance when used for data warehouses and other query-intensive applications. The following instructions show how to create a Vertica database…