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 ;  

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-1433545/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-1433545/