René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

DBA: The data block address

The DBA (here: not the database administrator but the data block address) uniquely identifies a database block in the database.
Behind such a database block address is a datafile number and the block number within that database file.
The datafile number can be found with dbms_utility.data_block_address_file. The block number within this file can be found with dbms_utility.data_block_address_block. A database block address can be constructed from a datafile number and a block number with make_data_block_address.