Cache
And Query
This is the
resource page of the UKOUG 2012 presentation.
Some snapshots of the
presentation 1 2 3 4
Abstract
Materialized views are
reliable working horses but always a bit stale (refresh on demand) or a bit
intrusive (refresh on commit). Can the "just in time" concept of
query cache invalidation be useful here?
After an elementary introduction
of the query cache mechanisms a case study about the use of Database Change
Notification to control refresh of materialized views is presented.
Presentation slides
Paper to the presentation
Groovy snapper script to monitor the result
cache efficiency
DB scripts
|