Dumps
ROW_CACHE
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
|