Shulou(Shulou.com)06/01 Report--

Get the actual physical storage address of the data row through rowid:

Select dbms_rowid.rowid_relative_fno (rowid) | |'_'| | dbms_rowid.rowid_block_number (rowid) | |'_'| | dbms_rowid.rowid_row_number (rowid) location from emp

Result: for example, 4 "151" 0, which represents the 0th row record of the 151st data block with the physical storage address of file 4 (the record number of the data row record in the data block starts from 0)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.