Roy today answered an interesting question on one of our internal mailing lists. And this reminds me to pick up that piece of information as…
View More Why you shouldn’t set OPTIMIZER_FEATURES_ENABLE
Tag: oracle
Oracle SQL profile and baselines
This post highlights the differences between SQL profile and baselines in Oracle® and explains how it works when tuning a query. Optimizer, profile, and baseline…
View More Oracle SQL profile and baselines
How to upgrade ORACLE 11G to 19C
My Environment for this practice Prerequisites: Before starting the upgrade make sure you have done the below checklist: Stop the Listener Take full database backup…
View More How to upgrade ORACLE 11G to 19C
Upgrade Database From 11g To 12c Manually
A database can be upgraded either using DBUA or manual method. But for major production databases, it is better to do it manually, so that…
View More Upgrade Database From 11g To 12c Manually
Step by Step Oracle Database Upgrade from 11g (11.2.0.4) to 12c (12.2.0.1) using DBUA
Here we are going to demonstrate step-by-step Oracle database upgrades from 11g (11.2.0.4) to 12c (12.2.0.1), same steps can be followed to upgrade to 12.1.0.2 as well.…
View More Step by Step Oracle Database Upgrade from 11g (11.2.0.4) to 12c (12.2.0.1) using DBUA
How to Upgrade from 11.1.0.7 to 11.2.0.3 on Linux
Part I – Installing and patching the software Occasionally during our regular DBA tasks, we get a client request or simply notice the need and…
View More How to Upgrade from 11.1.0.7 to 11.2.0.3 on Linux
orapwd enforces password complexity rules in 12.2.0.1
Starting with Oracle Database 12.2.0.1 the orapwd utility – used to create Password Files for remote authentication – enforces complexity rules for the provided password.…
View More orapwd enforces password complexity rules in 12.2.0.1
What is the difference between Oracle Client 19c and Oracle Client Home 19c?
When I tried to download and install Oracle client 19c, it was my surprise that there are two different versions. See the following information from…
View More What is the difference between Oracle Client 19c and Oracle Client Home 19c?
Enabling High Performance Data Streaming with the Memoptimized Rowstore
The Memoptimized Rowstore enables high performance data streaming for applications, such as Internet of Things (IoT). About the Memoptimized Rowstore The Memoptimized Rowstore enables high…
View More Enabling High Performance Data Streaming with the Memoptimized Rowstore
Oracle SQL Profile swapping
SQL tuning is one of the main duty covered by Database Administrator. It is not easy and requires both technology knowledge and sql-development skills. It…
View More Oracle SQL Profile swapping