René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
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.
|