Oracle一个块（Block）最多能装多少行

create table test_blocknum (id varchar2(1));


begin
for i in 1 .. 8000 loop
    insert into test_blocknum values ('a');
end loop;
commit;
end;
/

select dbms_rowid.rowid_relative_fno(rowid) f,
       dbms_rowid.rowid_block_number(rowid) b 
from test_block_num;

dbms_rowid.rowid_relative_fno(rowid) f #ROWID的相对文件号 https://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_rowid.htm#ARPLS67770
dbms_rowid.rowid_block_number(rowid) b #ROWID的数据块号 https://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_rowid.htm#ARPLS67762
       

select f, b, count(*)
    from (select dbms_rowid.rowid_relative_fno(rowid) f,
                  dbms_rowid.rowid_block_number(rowid) b 
           from test_block_num)
group by f, b;

show parameter db_block_size