Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

rows in a block

don123Nov 23 2018 — edited Nov 29 2018

I have read some articles online on number of rows per block, by increasing PCTFREE so that table is not dense.

Will this reduce contention for blocks in buffer ?

If there is advantages how many rows per block are suitable ?

I have following situation (11gR2, 8K block size) and want to know the advantages and disadvantages of minimizing rows per block. In this case rows per block are around 280.

select num_rows, blocks, avg_row_len from ALL_TAB_STATISTICS where owner='PMS' and table_name='PTDATA';

1653880           29477           105

Thanks

Comments
Post Details
Added on Nov 23 2018
12 comments
1,362 views