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

im prepare the OCE exam. i have no idea wat the procedure.plz give me some suggestions

0 Answers   HCL,


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,


I would like to know about Oracle Online Course certification (Finance)

0 Answers   Accenture,


Can you pls tel me there is any certification for Peoplesoft hrms?

1 Answers  


hi, i did ocp dba 9i in 2009 but not get job on oracle,now i want to continue my career as oracle dba what i do next .?

0 Answers  






I would like to know passing marks for oracle certification course module 1....

1 Answers  


hi thiz is rahul i want to do my ocp certification can any one plz guide me with full details

0 Answers  


Sir, what are the certification courses available in peoplesoft. I have completed my B.com (1991) and currently working in IT sector on peoplesoft financial module.where i can do this certification.

0 Answers  


SQL>select 'yakub' pasha from dual; (what is the output and how it happen)

3 Answers  


What is the exam fees for oca,ocp,ocm certification course in Bangalore?

1 Answers   Oracle,


hai, i think to do certification in oracle 11i. Can any one help me regarding fee, duration , preparation, and how much it is use full for getting a good job.

0 Answers  


Can you please send me the dups for the OCA certification?

2 Answers   IBM,


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)