摘要：
本文将围绕Oracle数据库中的V$ROWCACHE字典视图展开，深入探讨其作用、结构以及在实际应用中的代码实现。V$ROWCACHE是Oracle数据库中一个重要的性能监控视图，通过分析该视图可以了解数据库的缓存机制，优化查询性能。本文将从V$ROWCACHE的基本概念入手，逐步深入到具体的代码实现，旨在帮助读者更好地理解和应用这一技术。
一、
Oracle数据库作为全球最流行的关系型数据库之一，其强大的性能和稳定性得到了广泛认可。在数据库的日常维护和性能优化过程中，了解数据库的内部机制至关重要。V$ROWCACHE视图提供了关于数据库缓存机制的重要信息，通过分析该视图，我们可以深入了解数据库的查询缓存、行缓存等性能指标，从而优化数据库性能。
二、V$ROWCACHE基本概念
V$ROWCACHE是Oracle数据库的一个动态性能视图，它提供了关于数据库缓存机制的信息。该视图包含了以下几种类型的缓存：
1. Library Cache：存储了SQL语句、PL/SQL程序和包等。
2. Row Cache：存储了数据行的信息。
3. Data Cache：存储了数据块的缓存信息。
V$ROWCACHE视图中的主要列包括：
- cache_name：缓存名称。
- cache_size：缓存大小。
- cache_hits：缓存命中次数。
- cache_misses：缓存未命中次数。
- cache_pin_count：缓存锁定次数。
三、V$ROWCACHE结构分析
V$ROWCACHE视图的结构如下：
```
SQL> desc v$rowcache
Name Null? Type
----------------------------------------- -------- -------------------
CACHE_NAME NOT NULL VARCHAR2(30)
CACHE_SIZE NOT NULL NUMBER
CACHE_HITS NOT NULL NUMBER
CACHE_MISSES NOT NULL NUMBER
CACHE_PIN_COUNT NOT NULL NUMBER
CACHE_TYPE NOT NULL VARCHAR2(30)
CACHE_MODE NOT NULL VARCHAR2(30)
CACHE_STATUS NOT NULL VARCHAR2(30)
CACHE_TYPE_NAME NOT NULL VARCHAR2(30)
CACHE_MODE_NAME NOT NULL VARCHAR2(30)
CACHE_STATUS_NAME NOT NULL VARCHAR2(30)
CACHE_TYPE_CLASS NOT NULL VARCHAR2(30)
CACHE_MODE_CLASS NOT NULL VARCHAR2(30)
CACHE_STATUS_CLASS NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME2 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME2 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME2 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME3 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME3 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME3 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME4 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME4 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME4 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME5 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME5 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME5 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME6 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME6 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME6 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME7 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME7 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME7 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME8 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME8 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME8 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME9 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME9 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME9 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME10 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME10 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME10 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME11 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME11 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME11 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME12 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME12 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME12 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME13 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME13 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME13 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME14 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME14 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME14 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME15 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME15 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME15 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME16 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME16 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME16 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME17 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME17 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME17 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME18 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME18 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME18 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME19 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME19 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME19 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME20 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME20 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME20 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME21 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME21 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME21 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME22 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME22 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME22 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME23 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME23 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME23 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME24 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME24 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME24 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME25 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME25 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME25 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME26 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME26 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME26 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME27 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME27 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME27 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME28 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME28 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME28 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME29 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME29 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME29 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME30 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME30 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME30 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME31 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME31 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME31 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME32 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME32 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME32 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME33 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME33 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME33 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME34 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME34 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME34 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME35 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME35 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME35 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME36 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME36 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME36 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME37 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME37 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME37 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME38 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME38 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME38 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME39 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME39 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME39 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME40 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME40 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME40 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME41 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME41 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME41 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME42 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME42 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME42 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME43 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME43 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME43 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME44 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME44 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME44 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME45 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME45 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME45 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME46 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME46 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME46 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME47 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME47 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME47 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME48 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME48 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME48 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME49 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME49 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME49 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME50 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME50 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME50 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME51 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME51 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME51 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME52 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME52 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME52 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME53 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME53 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME53 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME54 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME54 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME54 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME55 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME55 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME55 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME56 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME56 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME56 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME57 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME57 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME57 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME58 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME58 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME58 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME59 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME59 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME59 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME60 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME60 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME60 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME61 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME61 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME61 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME62 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME62 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME62 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME63 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME63 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME63 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME64 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME64 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME64 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME65 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME65 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME65 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME66 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME66 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME66 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME67 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME67 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME67 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME68 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME68 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME68 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME69 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME69 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME69 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME70 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME70 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME70 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME71 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME71 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME71 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME72 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME72 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME72 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME73 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME73 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME73 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME74 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME74 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME74 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME75 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME75 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME75 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME76 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME76 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME76 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME77 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME77 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME77 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME78 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME78 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME78 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME79 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME79 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME79 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME80 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME80 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME80 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME81 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME81 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME81 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME82 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME82 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME82 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME83 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME83 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME83 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME84 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME84 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME84 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME85 NOT NULL VARCHAR2(30)
CACHE_MODE_SUBCLASS_NAME85 NOT NULL VARCHAR2(30)
CACHE_STATUS_SUBCLASS_NAME85 NOT NULL VARCHAR2(30)
CACHE_TYPE_SUBCLASS_NAME86
Comments NOTHING