ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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!
Oracle Database
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER