Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

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