Buffer Dump
The buffer dump is same as the buffers dump discussed in the preceding session, except as regards the LRU information. The buffer dumps all the buffers in the buffer cache of the given Data Block Address (DBA) at level 10. This can be used to dump the buffers of the known DBA. Starting from Oracle8 you need to set the SET_TSN_P1 event because the address is taken as relative DBA, which is specific to a tablespace. This dump is usually taken to investigate the buffer copies of the single known buffer. Note the number of CR copies of the specific buffer in the buffer cache is limited by the undocumented parameter_DB_BLOCK_MAX_CR_DBA. You may need to use the buffer dump when the error is related to a single buffer (or a set of buffers). ...
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.
