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 |
what is the exact syllabus for oracle certification level 1?
hi i'm jhaniya i'm a fresher i've completed course in informatica and cognos but yet nw i din get a job ..so planning to study oracle will tis match ..even if i get placed in oracle can i then get into informatica wil this work out ..which part can i choose in oracle ..
Can any one provide dumps for Oracle Fusion CRM certification (1Z1-456)
I have b licence . I want c licenc. What can i do it. I have 5 years HT experience .
0 Answers TNEB Tamil Nadu Electricity Board,
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 any one provide dupms for Oracle Business Intelligence Applications 7 for CRM Essentials certification exam(1Z0- 524)
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.
i have 6 years of gap after doing bca. how to get a good job now.
Hi , I am planning to take up OCA certification in next 3 months.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 mukund.kanabargi@gmail.com.Please give me any tips if possible.
sir plse tell me oracle 10g ocp certification material and previous papers send to me
oracle what kind of certificate as valided in nowadays. how long during studied for this certificats.