| Row chaining [message #170742] |
Fri, 05 May 2006 01:12  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
Hi,
Please anyone explain me,what is row chaining & row migration?
Thanks,
Gajini
|
|
|
|
| Re: Row chaining [message #170750 is a reply to message #170742] |
Fri, 05 May 2006 01:19  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
A simple search on google or this site would reveal the answer:
"Row migration occurs when a database block doesn't contain enough free space to accommodate an update statement. In that case, the server moves the row to another block and maintains a pointer to new block in the row's original block."
"Row chaining in contrast, occurs when no single db block is large enough to accommodate a particular row. This is common when a table contains several large data types. It will then reside in multiple database blocks."
Source: http://www.orafaq.com/forum/t/165/2/
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
