DirectPathReads

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

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.

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.

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://csdahua.cn/article/poiioc.html
扫二维码与项目经理沟通

我们在微信上24小时期待你的声音

解答本文疑问/技术咨询/运营咨询/技术建议/互联网交流