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