Oracle Memory Management Question:
How does Space allocation table place within a block?
Answer:
Each block contains entries as follows
Fixed block header
Variable block header
Row Header,row date (multiple rows may exists)
PCTEREE (% of free space for row updation in future).
Fixed block header
Variable block header
Row Header,row date (multiple rows may exists)
PCTEREE (% of free space for row updation in future).
Previous Question | Next Question |
What is the functionality of SYSTEM table space? | What is the role of PCTFREE parameter is storage clause? |