what is row chaining and row migration?
Answers were Sorted based on User's Feedback
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 |
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 |
im prepare the OCE exam. i have no idea wat the procedure.plz give me some suggestions
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.
I would like to know about Oracle Online Course certification (Finance)
Can you pls tel me there is any certification for Peoplesoft hrms?
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 .?
I would like to know passing marks for oracle certification course module 1....
hi thiz is rahul i want to do my ocp certification can any one plz guide me with full details
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.
SQL>select 'yakub' pasha from dual; (what is the output and how it happen)
What is the exam fees for oca,ocp,ocm certification course in Bangalore?
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.
Can you please send me the dups for the OCA certification?