Buffers Dump
The named dump buffers can be used to dump the buffer cache. The information produced varies. Depending on the level specified, the trace file will contain information pertaining to buffer headers, users and waiters of that buffer, position of that buffer, and other details, such as the object number and tablespace number. The dump file also holds the LRU information about the buffers.
The size of the trace file depends on the init.ora parameter DB_CACHE_SIZE or DB_BLOCK_BUFFERS, depending on the version of the database. You may need to dump the buffer cache if the problem is related to buffer corruption or any other buffer cache related issues. In the Real Application Clusters environment, it is required to dump the buffers in all ...
Get Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
