limit one row per block
Hi All
I have a very small table which is subject to massive amount of update and loads of pessimistic locking.
I like to force this table to have only 1 row per block.
average row length is 57
block size 8K
db 12c
I can play around with PCTfree using very a value
this is a very simple method but there is no assurance that I get 1 row per block
I can create a cluster and move this table in to the cluster and set it so it uses one row per block
too much work and changes to database but does give me what I need