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 |
how can i get oracle certifications logo?
Hi, I am planning for oracle datawarehousing fundamentals 11g certification.. 1Z0-515.. Any having dumps or materials for this.. pls provide me..
I would like to know all the details about oracle certification on different levels.
16 Answers Algo, CMC, CybAge, HCL, IBM, Oracle, TCS, Zensar,
i would like to know oracle dba on 10g/11i certification fee structure ..for all exams please help me
i required oracle HRMS certification material , if your friends or your colleagues have this material , then pl send me ... or either you find any where in website then send me links
Which is the good institution for ORACLE certification in delhi?
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)
Can any one provide dumps for Oracle Fusion CRM certification (1Z1-456)
How to specify multiple value
I would like to know passing marks for oracle certification course module 1....
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.