X hits on this document

106 views

0 shares

0 downloads

0 comments

4 / 38

4

juliandyke.com

© 2007 Julian Dyke

Result Cache Introduction

Introduced in Oracle 11.1

Allows results of a query to be cached in SGA

When subsequent queries execute requiring the same result set, results are retrieved from shared pool

Potentially reduces

amount of physical I/O

amount of logical I/O

number of sorts

amount of CPU

Document info
Document views106
Page views106
Page last viewedThu Dec 08 19:27:44 UTC 2016
Pages38
Paragraphs703
Words2667

Comments