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
Category: Oracle
Oracle
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
Multiple rows insert vs single row insert
The performance of ‘extract, transform, load’ (ETL) processes for large quantities of data can always be improved by objective testing and experiment with alternative techniques.…
View More Multiple rows insert vs single row insert
APPEND_VALUES Hint in Oracle Database 11g Release 2
We have been able to take advantage of the performance benefits of direct-path inserts in “INSERT … SELECT” operations for a long time using the APPEND…
View More APPEND_VALUES Hint in Oracle Database 11g Release 2
Oracle Automatic (Shared) Memory Management
Automatic Shared Memory Management Automatic Shared Memory Management: OverviewAutomatic Shared Memory Management (ASMM) simplifies the configuration of the System Global Area (SGA). ASMM uses memory…
View More Oracle Automatic (Shared) Memory Management
How do I display and read the execution plans for a SQL statement
This post covers how you can use the PL/SQL package DBMS_XPLAN to display execution plan information. If you want to learn more about DBMS_XPLAN options,…
View More How do I display and read the execution plans for a SQL statement
Conventional and Direct Path Loads
Data Loading Methods SQL*Loader provides two methods for loading data: A conventional path load executes SQL INSERT statements to populate tables in an Oracle database. A direct…
View More Conventional and Direct Path Loads