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 is the difference between instance recovery and crash recovery?
What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?
What do you mean by sga and how is it different from pga?
What is the purpose of scan?
What is split brain syndrome in rac?
What is the volume management techniques used in oracle rac?
What are the file systems and volume management techniques used in oracle rac?
Explain the oracle real application clusters architecture?
What are the file storage options provided by oracle database for oracle rac?
How can we identify the resources for which the sessions are waiting?
Mention what is the difference between single instance environment and rac environment?
What is oracle real application clusters?