Hot blocks

msimons4
msimons4 used Ask the Experts™
on
What is a hot block?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
A database block or series of blocks that are accessed a LOT more than the rest.
Most Valuable Expert 2011
Top Expert 2012
Commented:
a block with significantly more activity than other blocks within the same segment

Author

Commented:
Thanks
Top Expert 2008

Commented:
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!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial