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:

成都创新互联公司长期为近1000家客户提供的网站建设服务，团队从业经验10年，关注不同地域、不同群体，并针对不同对象提供差异化的产品和服务；打造开放共赢平台，与合作伙伴共同营造健康的互联网生态环境。为勐海企业提供专业的做网站、网站建设，勐海网站改版等技术服务。拥有十年丰富建站经验和众多成功案例,为您定制开发。

• Execution of a CREATE TABLE AS SELECT statement

• Execution of an ALTER REBUILD or ALTER MOVE statement

• Reads from a temporary tablespace

• Parallel queries

• Reads from a LOB segment

 

Direct Path Reads

Direct Path Reads

Direct Path Reads

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.












文章名称：DirectPathReads
文章位置：http://scyingshan.cn/article/poiioc.html