Want your database to run faster? While common tuning techniques can prove quite helpful in resolving many performance issues, they don’t show the details of all the…
View More How to trace SQL sessions to identify Oracle Database bottlenecks
Month: July 2023
How to get access to download older Oracle versions?
In the Software Delivery Cloud (formerly known as eDelivery) you will find the following base releases of the Oracle database: And the other source for downloads is oracle.com.…
View More How to get access to download older Oracle versions?
Oracle COMPATIBLE VS OPTIMIZER_FEATURES_ENABLE
COMPATIBLE PARAMETER Understanding the COMPATIBLE Initialization ParameterIn Oracle Database 19c, when the COMPATIBLE initialization parameter is not set in your parameter file, the COMPATIBLE parameter…
View More Oracle COMPATIBLE VS OPTIMIZER_FEATURES_ENABLE
Why you shouldn’t set OPTIMIZER_FEATURES_ENABLE
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
MEMORY_TARGET, SGA_TARGET and PGA_AGGREGATE_TARGET
The memory structures that must be managed are the system global area (SGA) and the instance program global area (instance PGA). Oracle Database supports various…
View More MEMORY_TARGET, SGA_TARGET and PGA_AGGREGATE_TARGET
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