result cache,结果缓存,当表的访问方式"以读为主"前提下,从一张大表中过滤出"少量的记录"作为结果集的查询语句适合把查询结果集放入result cache,后续相同的查询语句可以直接从result cache里获取想要的结果,省去了CPU、I/O上的开销,result cache位于shared pool里的某一块区域中,其大小可以通过result_cache_max_size进行调整。
受益的查询特性:
Access Large Amount of Data
Return Few Rows
Execute Somewhat Frequently
Based on Slowly Changing Data
Limited Number of Bind Values: Results are cached by Bind Value
-- New in Oracle 11g, Improved in 11gR2
SQL Query Results (local and distributed)
PL/SQL Function Results
OCI Client Results
Cached Data is shared across executions
Automatically marked stale if underlying data is changed
Can Dramatically Increase Performance
Stores Results of Query or Function Call
Uses a Slice of the Shared Pool
Not Affected by Flushing Shared Pool
受益的查询特性:
Access Large Amount of Data
Return Few Rows
Execute Somewhat Frequently
Based on Slowly Changing Data
Limited Number of Bind Values: Results are cached by Bind Value
-- New in Oracle 11g, Improved in 11gR2
SQL Query Results (local and distributed)
PL/SQL Function Results
OCI Client Results
Cached Data is shared across executions
Automatically marked stale if underlying data is changed
Can Dramatically Increase Performance
Stores Results of Query or Function Call
Uses a Slice of the Shared Pool
Not Affected by Flushing Shared Pool
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-1433503/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-1433503/