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
Tag: oracle
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
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
APPEND_VALUES and SYS_DL_CURSOR Hints with HCC
The APPEND_VALUES hint was introduced in 11.2 to allow direct path inserts with variables using the VALUES clause. i.e. INSERT INTO XYZ (COL1, COL2) VALUES…
View More APPEND_VALUES and SYS_DL_CURSOR Hints with HCC
How to Increase MEMORY_TARGET
Before you can increase memory in oracle database, you must first understand four oracle memory parameters which govern the instance. SGA_TARGET and SGA_MAX_SIZE MEMORY_TARGET and…
View More How to Increase MEMORY_TARGET
Adaptive Cursor Sharing in Oracle Database 11g Release 1
DBAs are always encouraging developers to use bind variables, but when bind variables are used against columns containing skewed data they sometimes lead to less…
View More Adaptive Cursor Sharing in Oracle Database 11g Release 1
How to Swap SQL_Profiles?
The central idea behind “swapping” SQL profiles is simple.Β Β You define a SQL profile that specifies the SQL statement that you want to tune, and an…
View More How to Swap SQL_Profiles?