Figure 6-27. Given the buffer's block number and file number, along with accessing dba_extents and dba_data_files, we can glean other information about the block. In this case, the buffer having three sessions waiting for access is part of the orders table.

Every Oracle segment has a header block. For example, as shown in Figure 6-28, both table segments and undo segments have a single header block. The first block of the first extent is the segment's header block. Header blocks are different from the remaining object's blocks because they contain something special. And that specialness is dependent on the segment type. This is why we needed to first determine the segment type. Now we will determine if the block is a header block.

Figure 6-28. Shown are two segment types: an undo segment and a table segment. Each segment has two extents. Each extent contains eight contiguous blocks, and each segment has a single segment header block. In Figures 6-25 and 6-27, the orders table block 4,54 was busy, with three sessions waiting to access.