msimons4
asked on
Hot blocks
What is a hot block?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Hot block is an oracle block that cause contention for different reasons:
1. There can be too many Oracle records in a block (here we have to change PCTFREE and PCTUSED parameters)
2. There can be to little number of simultaneous transactions allowed to the block (increase the number of transactions losing some space in the header of the blocks)
3. Heavily used index (here INITTRANS parameter should be increased).
4. Undo segments can also generate hot blocks - mainly the header blocks, so we have to increase their number.
As a joke: Trafic jams and hot blocks ... are similar!
1. There can be too many Oracle records in a block (here we have to change PCTFREE and PCTUSED parameters)
2. There can be to little number of simultaneous transactions allowed to the block (increase the number of transactions losing some space in the header of the blocks)
3. Heavily used index (here INITTRANS parameter should be increased).
4. Undo segments can also generate hot blocks - mainly the header blocks, so we have to increase their number.
As a joke: Trafic jams and hot blocks ... are similar!
ASKER