PL/SQL script: Check a Oracle View
This PL/SQL script can be used to find issues with Oracle Views. For example it shows data type conversions being done that could result in an sub optimal plan.
PL/SQL script: Empty schema
This PL/SQL script can be used to remove all objects of one ore more schemas. This might be used in preparation of an DataPump import.
PL/SQL script: Resizing Oracle Redo Logs
This PL/SQL script can be used to resize Oracle Redo Logfiles. All existing logfile members of all groups will be resized to a specific size.
IBM Informix installation on Linux
In this post we will install IBM Informix 12.10 FC16 (Developer Edition) on Linux. This is a full featured free of charge Developer version.
Install Oracle RAC 19c on Linux
This post describes the mostly unattended installation of a 2 node Oracle Real Application Cluster 19c on Oracle Linux 9.5.
Install Oracle Database 19c on Windows
This post shows the steps to install Oracle Database 19c on Windows Server Datacenter 2022.
Oracle Autonomous Health Framework
This article describes the installation and usage of the Oracle Autonomous Health Framework (AHF) on a Linux system.
Unattended Installation of Windows Server 2022 on VirtualBox
This post describes the unattended installation of a Windows Server 2022 Virtual Machine in Oracle VirtualBox.
Install Oracle Database 12.1 SE2 on Windows
This post shows the steps to install Oracle Database 12.1 Standard Edition 2 (SE2) on Windows Server 2008 R2.
Reclaim Unused Space
This post describes the steps that can be used to free unused space in database objects. Sometimes this is also called defragmentation.