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 |
1)Can Any body tell total no. of question in OCA and OCP? 2)Can i directly appear the OCP exam without attending OCA exam?
hai what are the certification courses available in oralcle certification
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.
I have done GNIIT software engneering and B.COM and also i have 1yr exp in oracle DBA can i do oracle DBA certification plz adviced me frnds....as early possible with certification details...
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.
i want to do oracle certification..could any one pleas tell me what is the level 1 certification exam in oracle? how do we get dumps?
being in business intelligence and data warehousing,what would be the importance of a oracle certification how much would it cost me
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.
what is the meaning of this query Alter database force logging.
where the bestone of the oracle certification tutorials in the hyderabad plz give me full contact address to my ramu.nani28@gmail.com thank you frnds
what is the exact syllabus for oracle certification level 1?
What is the default value of Boolean Operator? a.Null b.True c.False d.none of the above
15 Answers CTS, Infosys, Wipro,