有哪些操作可以导致direct reads(direct path reads) 参考文章: Parallel Execution and Direct Reads (Doc ID 237328.1) 1.并行创建table 或者创建index 2.sort 3.在11.2中全表扫描会以direct read方式来,以减少对buffer cache的冲击. 另外注: direct reads(direct path reads) 是从disk 读取数据,发送给PGA. |
Archiver|知识站 ( 鲁ICP备20004068号-1 )
GMT+8, 2020-6-23 22:50 , Processed in 0.013274 second(s), 17 queries .