Oracle 11.2.0.1 Result Cache 測試 - 8

ID     NAME              VALUE 
---  -----------------  --------
1 Block Size (Bytes) 1024            --- memory block的大小
2 Block Count Maximum 62944     --- 允許存放在result cache的記憶體塊的最大量,result_cache_max_size = 62944K 
3 Block Count Current 12160            --- 目前result cache記憶體塊分配的數量
4 Result Size Maximum (Blocks)  3147     --- RESULT_CACHE_MAX_RESULT, 該引數為單個SQL查詢語句設定可
                                                 使用的最大Result Cache容量預設等於 result_cache_max_size 的5%大小。
5 Create Count Success 55426          --- Number of cache results successfully created 
6 Create Count Failure 5            --- Number of cache results that failed to create
7 Find Count 44255              --- Number of cached results that were successfully found 
8 Invalidation Count 32711    --- Total number of invalidations 
9 Delete Count Invalid 48076          --- Number of invalid cached results deleted 
10 Delete Count Valid 0              --- Number of valid cached results deleted 
11 Hash Chain Length  1               --- Average length of items in the hash chain

在之前的視窗再次執行同樣的SQL : 
SQL> set autotrace traceonly 
SQL> set timing on 
SQL> select /*+ RESULT_CACHE */ object_id, object_name,object_type,status from apps.test_result_cache  where mod(object_id,3)=1;
66661 rows selected.
....  
Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
          0  consistent gets
          0  physical reads
          0  redo size
    3006999  bytes sent via SQL*Net to client

PL/SQL DEV中再次查詢 : 
SQL> select * from  v$result_cache_statistics ;