What do you understand by row chaining?
Answer / Prasenjeet Sarkar
Row chaining in Oracle occurs when a deleted row is not actually removed from the table but marked as 'rolled back' or 'inactive'. The space occupied by the row is not immediately released, causing potential performance issues. Row chaining can be controlled through various methods such as purging old data, disabling row movement, and using large tablespaces.
| Is This Answer Correct ? | 0 Yes | 0 No |
Mention what are the key characteristics of rac or why to use rac?
Mention what is the difference between instance recovery and crash recovery?
What is the function of grid naming service used in oracle rac
What is olr?
What are the tools provided in oracle enterprise manager?
What is oracle real application clusters?
How can we monitor the space allocations in a database?
Mention what are the tools provided in oracle enterprise manager?
Mention how oracle flex asm works?
What is the difference between media recovery & crash recovery?
How do you recover a lost control file?
What do you understand by row chaining?