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 to specify multiple value
what is row chaining and row migration?
Can you pls tel me there is any certification for Peoplesoft hrms?
I would like to know passing marks for oracle certification course module 1....
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?
Can anyone plz let me know the output for this query? select 1 from dual minus select 'a' from dual;
I am planing for sql exam so please help me about exam questions.
Dumps for 1z0-108 Weblogic server administration 11g or 1z0-102 Weblogic server administration 10g
Hi All..! This is Ratna,Im working as a Oracle apps Technical Consultant with 2yrs of experience.I started working on Hrms module,I feel like going for functional certification in HRMS module.Can any one suggest me on the below questions 1. how many papers are there for Oracle HRMS certification, and what is fees for each paper. 2. can a person pass the paper by reading the related documention provided by oracle. 3. do anybody have bunch of questons for oracle HRMS and like to share.
is any oracle education partner in Bangalore?
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,