oracle rowid - sergeyzolotukhin/learn-java-gradle GitHub Wiki

The format is: OOOOOO.FFF.BBBBBB.RRR
    OOOOOO is the object ID
    FFF is the file number
    BBBBBB is the block number
    RRR is the row number

select rowid, DBMS_ROWID.ROWID_BLOCK_NUMBER(rowid) block_id, dbms_rowid.rowid_row_number(ROWID) as row_no, s.*
from SR_SCHEDULE s
;

select rowid, DBMS_ROWID.ROWID_BLOCK_NUMBER(rowid) block_id, dbms_rowid.rowid_row_number(ROWID) as row_no, s.*
from SR_SCHEDULE_VALUE_NUMBER s
;

cr - consistent read - LIO
pr - physical read
pw - physical write.