Database Administration (MOSC)

MOSC Banner

limit one row per block

edited Aug 16, 2016 8:52PM in Database Administration (MOSC) 14 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center