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.
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.
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.
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.
Oracle Cheat Sheet
This blog post contains some random Oracle commands or SQL statements to have them at hand when they are needed.
This content requires the Adobe Flash Player
This post shows a way to view web pages that contain shockwave flash content. Use with caution since flash content is considered unsafe.
Oracle Statspack
In this post we are going to install and use Oracle Statspack which is a free alternative to AWR reports. It is mainly used for performance tuning.