what is row chaining and row migration?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

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

2644


Hi All..! This is Ratna,Im working as a Oracle apps Technical Consultant with 2yrs of experience.I started working on Hrms module,I feel like going for functional certification in HRMS module.Can any one suggest me on the below questions 1. how many papers are there for Oracle HRMS certification, and what is fees for each paper. 2. can a person pass the paper by reading the related documention provided by oracle. 3. do anybody have bunch of questons for oracle HRMS and like to share.

3241


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.

1480


Does any one have oracle dumps for this exam - 1Z0-147: Program with PL/SQL ?

1014


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 .?

2077






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

2176


I have b licence . I want c licenc. What can i do it. I have 5 years HT experience .

1440


I completed MCA and also I have OCA certification. Now I am working as a Application Developer in Asp.net but I need a job in Oracle Application or related to Sql or Pl/Sql.

2262


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

1722


HI, I have completed my M.com and MBA and currently working in IT sector in HR Recruitment. i just want to do Oracle HRMS functional course. And is there is any study center in Coimbatore from where i can do this certification.

1913


Can any one provide dumps for Oracle Fusion CRM certification (1Z1-456)

4636


Hi, I am planning for oracle datawarehousing fundamentals 11g certification.. 1Z0-515.. Any having dumps or materials for this.. pls provide me..

2141


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.

2401


explain procedure of the OCJP cerification, and exam fee please explain

3714


what is the exact syllabus for oracle certification level 1?

3687