Oracle Database SQL Tuning Guide---8 Optimizer Access Paths

Direct Path Reads
In a direct path read, the database reads buffers from disk directly into the PGA, bypassing the SGA entirely.
The following figure shows the difference between scattered and sequential reads, which store buffers in the SGA, and direct path reads.

Situations in which Oracle Database may perform direct path reads include:

Execution of aCREATE TABLE AS SELECTstatement

Execution of anALTER REBUILDorALTER MOVEstatement

Reads from a temporary tablespace

Parallel queries

Reads from a LOB segment





Direct Path Reads

In adirect path read, the database reads buffers from disk directly into the PGA, bypassing the SGA entirely.

The following figure shows the difference between scattered and sequential reads, which store buffers in the SGA, and direct path reads.

Direct Path Reads

In adirect path read, the database reads buffers from disk directly into the PGA, bypassing the SGA entirely.

The following figure shows the difference between scattered and sequential reads, which store buffers in the SGA, and direct path reads.

Direct Path Reads

In adirect path read, the database reads buffers from disk directly into the PGA, bypassing the SGA entirely.

The following figure shows the difference between scattered and sequential reads, which store buffers in the SGA, and direct path reads.

Direct Path Reads

In adirect path read, the database reads buffers from disk directly into the PGA, bypassing the SGA entirely.

The following figure shows the difference between scattered and sequential reads, which store buffers in the SGA, and direct path reads.

Direct Path Reads
In a direct path read, the database reads buffers from disk directly into the PGA, bypassing the SGA entirely.


The following figure shows the difference between scattered and sequential reads, which store buffers in the SGA, and direct path reads.
Direct Path Reads
In a direct path read, the database reads buffers from disk directly into the PGA, bypassing the SGA entirely.


The following figure shows the difference between scattered and sequential reads, which store buffers in the SGA, and direct path reads.