X hits on this document

98 views

0 shares

0 downloads

0 comments

37 / 38

37

juliandyke.com

© 2007 Julian Dyke

Result Cache Conclusions

Server side result cache has potential to eliminate repeated logical I/Os

Improved response times

Lower CPU

Potentially lower physical I/O

Consider modifying code to use [in-line] views instead of sub queries

Some questions over scalability

Locking algorithm appears to have been improved between 11.1 beta and 11.1 production

V$LOCK_TYPE parameters for RC enqueue incorrect in 11.1 production

Impact of using result cache can easily be assessed when using RESULT_CACHE hint (MANUAL mode)

Impact of FORCE mode much harder to assess

Document info
Document views98
Page views98
Page last viewedWed Dec 07 14:48:08 UTC 2016
Pages38
Paragraphs703
Words2667

Comments