Oracle 11.2.0.1 Result Cache 測試 - 1

        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