Tag: Oracle 18c

Reduce the REDO generation in your Oracle database by setting one parameter.

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular post from the past. Today’s post was originally published on April 29, 2019. Blogger’s Note: The information in this…

This blog post will show you how to install 18c Grid and upgrade to 18.6.0.0. 1. Download the 18c binairy and Apr, 2019 PSU: 18c Grid: https://download.oracle.com/otn/linux/oracle18c/180000/LINUX.X64_180000_grid_home.zip Apr 2019 PSU: https://updates.oracle.com/Orion/Services/download/p29251992_180000_Linux-x86-64.zip?aru=22869122&patch_file=p29251992_180000_Linux-x86-64.zip OPatch 12.2.0.1.17: https://updates.oracle.com/Orion/Services/download/p6880880_180000_Linux-x86-64.zip?aru=22870225&patch_file=p6880880_180000_Linux-x86-64.zip 2. Prepare OS for Oracle installation,…

WhenI was upgrading Grid to 18c, the final step was to run gridSetup.sh -executeConfigTools, which failed. Unfortunately, the error provided was not very descriptive or useful. In this post, I will demonstrate how I went about troubleshooting the failure. To…

My colleague and friend Gleb Otochkin has already blogged about installing 18c – Installing Oracle 18c using command line – but I thought that I would share my experience. My plan was to upgrade my 12.2 pluggable database to 18c…

A recent Twitter thread had an interesting test case of the optimizer choosing sub-optimal skip scan over range scan. I’ve checked what’s going on, and it happens to be a known bug. Here’s a slightly simplified test case: We have…