X hits on this document

100 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 views100
Page views100
Page last viewedWed Dec 07 20:31:24 UTC 2016
Pages38
Paragraphs703
Words2667

Comments