The row cache is also known as the dictionary cache
The following command can be used to dump the row cache:
ALTER SESSION SET EVENTS 'immediate trace name row_cache level level';
where level is one of the following:
Level | Description |
1 | Dump row cache statistics |
2 | Include hash table histogram |
8 | Include dump of object structures |
For example:
ALTER SESSION SET EVENTS 'immediate trace name row_cache level 1';
The following ORADEBUG command has the same effect:
ORADEBUG DUMP ROW_CACHE level