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
Flush Bad SQL Plan from Shared Pool
Sometimes it is required to flush the BAD SQL_PLAN from shared_pool so that new (or old) better execution plan can be picked by SQL_ID 1)…
View More Flush Bad SQL Plan from Shared Pool
Postgres — Live Table Partitioning
the partitioning of 1TB of data on a live system, with zero downtime Summary A few months ago we faced an engineering challenge of having…
View More Postgres — Live Table Partitioning
Partitioning Existing Tables in Postgres
So, your database is growing rapidly, as, ideally, is your business. The problem is, its performance is getting worse. You’re starting to wonder whether partitioning…
View More Partitioning Existing Tables in Postgres
Oracle CBO is ignoring SYS_DL_CURSOR
Some days ago i came across with a pl/sql code where they used (for some reason) an Oracle hint called SYS_DL_CURSOR. I got it when i…
View More Oracle CBO is ignoring SYS_DL_CURSOR