what is row chaining and row migration?

Answers were Sorted based on User's Feedback



what is row chaining and row migration?..

Answer / daman

We will migrate a row when an update to that row would cause
it to not fit on the block anymore (with all of the other
data that exists there currently). A migration means that
the entire row will move and we just leave behind the
«forwarding address». So, the original block just has the
rowid of the new block and the entire row is moved.
Row chaining nstead of just having a forwarding address on
one block and the data on another we have data on two or
more blocks.

Is This Answer Correct ?    16 Yes 7 No

what is row chaining and row migration?..

Answer / nitun

Row Chaining happens when a row is too large to fit into a
single database block. For example, if you use a 8KB block
size for your database and you need to insert a row of 16KB
into it, Oracle will use 2/3 blocks and store the row in
chain of data blocks for that segment. And Row Chaining
happens only when the row is being inserted

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle Certifications Interview Questions

1)Can Any body tell total no. of question in OCA and OCP? 2)Can i directly appear the OCP exam without attending OCA exam?

4 Answers   Infosys, Oracle,


hai what are the certification courses available in oralcle certification

1 Answers  


How to prepare for doing OCA and is there books or any model questions or any site which helps us fro preparing our own? Please give me the complete information if possible.

2 Answers  


I have done GNIIT software engneering and B.COM and also i have 1yr exp in oracle DBA can i do oracle DBA certification plz adviced me frnds....as early possible with certification details...

0 Answers   TCS,


Hi , I am planning to take up OCA certification.Can you please provide me with the path for Oracle DBA certi.If any one of you have dumps for same,please mail them to sajagporwal123@gmail.com.Please give me any tips if possible.

0 Answers  






i want to do oracle certification..could any one pleas tell me what is the level 1 certification exam in oracle? how do we get dumps?

0 Answers  


being in business intelligence and data warehousing,what would be the importance of a oracle certification how much would it cost me

0 Answers   Wipro,


Hi. I wish to appear for OCA exam. Can anyone pls guide me on the syllabus n fee structure of the exam. I know that there are 2 tracks : developer and dba. What is the difference between the two? All suggestions are welcome. Thanks.

0 Answers   Aptron, Syntel,


what is the meaning of this query Alter database force logging.

1 Answers  


where the bestone of the oracle certification tutorials in the hyderabad plz give me full contact address to my ramu.nani28@gmail.com thank you frnds

1 Answers   Oracle,


what is the exact syllabus for oracle certification level 1?

0 Answers  


What is the default value of Boolean Operator? a.Null b.True c.False d.none of the above

15 Answers   CTS, Infosys, Wipro,


Categories
  • Cisco Certifications Interview Questions Cisco Certifications (2321)
  • Microsoft Certifications Interview Questions Microsoft Certifications (171)
  • Sun Certifications Interview Questions Sun Certifications (45)
  • CISA Certification Interview Questions CISA Certification (744)
  • Oracle Certifications Interview Questions Oracle Certifications (64)
  • ISTQB Certification Interview Questions ISTQB Certification (109)
  • Certifications AllOther Interview Questions Certifications AllOther (295)