X hits on this document

156 views

0 shares

0 downloads

0 comments

6 / 38

6

juliandyke.com

© 2007 Julian Dyke

Result Cache SQL Query Result Cache

For query results to be reusable:

Read consistent query used to build result set must retrieve most current committed state of data

or

Query must point to an explicit point in time using flashback query

Cached results become invalid when data in underlying tables is modified

Includes ongoing transactions

In RAC, result cache is instance specific

Can be different size in each instance

Document info
Document views156
Page views158
Page last viewedTue Jan 24 05:12:02 UTC 2017
Pages38
Paragraphs703
Words2667

Comments