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 |
i wrote my oca and ocp exam last year novemeber i got my oca certificate but havnt gotten my ocp i completed my hands-on and an email was sent to me saying my ocp will be delivered in 30days its 4months now and i have not seen my certificate.i will loose my job next month cos of that pls help me
2 Answers Cognizant, Infogain, Infosys, Ora Tech,
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
i would like to know oracle dba on 10g/11i certification fee structure ..for all exams please help 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,
Hi, I am doing mba hr and having 4.4 yrs experience in marketing research and accounts payable together. Now i have 2 yrs of carrier break. Will it be advisable to do oracle hrms certification and grab new opportunities?
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.
Does any one have oracle dumps for this exam - 1Z0-147: Program with PL/SQL ?
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.
Hi, I am planning to write OCP Certification (Oracle Functional) Here i need to complete 4 exams like 1Z0-200--Oracle eBusiness Fundamentals 1Z0-211--Oracle General Ledger Fundamentals (After this i need submitt Hands on Course form) 1Z0-212--Oracle Payable Fundamentals 1Z0-213--Oracle Receivable Fundamentals My question is what is Hands on course form and any training i need attendig? and when i have to attend between above exams?. Please suggest. Thanks
How the text files in the operating system are accesed through UTL_FILE package, if the user have no access to operating system.
hello friends. i m saravanan. my stream (B.Tech)Information Technology. i m seeking for job. now i plan to do informatica certification.. but this certification is only for experienced software professional. i m having no software experience. do u think is informatica certification is useful to my carrer..?? and pls explain which certification is better Oracle (Or) Informatica????? my mail id is ysaravananbtech@gmail.com mobile no is>> +91-9894060089
Which is the good institution for ORACLE certification in delhi?