| chaind rows [message #101445] |
Sat, 02 October 2004 06:19  |
sawsan
Messages: 15
Registered: October 2004
|
Junior Member |
|
|
hi
what is chaind rows and how they are made?
|
|
|
|
| Re: chaind rows [message #101449 is a reply to message #101445] |
Tue, 05 October 2004 03:39  |
Frank Naude
Messages: 4596
Registered: April 1998
|
Senior Member |
|
|
Hi,
A chained row is a row that is too large to fit into a single database block. For example, if you use a 4KB blocksize for your database, and you need to insert a row of 8KB into it, Oracle will use 3 blocks and store the row in pieces. The following conditions will cause row chaining:
- Tables whose rowsize exceeds the blocksize will have chained rows.
- Tables with long and long raw columns are prone to having chained rows.
- Table with more then 255 columns will have chained rows as Oracle break wide tables up into pieces.
Best regards.
Frank
|
|
|
|
|
|
| Re: chaind rows [message #101677 is a reply to message #101672] |
Fri, 18 February 2005 07:17 |
sawsan
Messages: 15
Registered: October 2004
|
Junior Member |
|
|
Hi,
A chained row is a row that is too large to fit into a single database block. For example, if you use a 4KB blocksize for your database, and you need to insert a row of 8KB into it, Oracle will use 3 blocks and store the row in pieces. The following conditions will cause row chaining:
- Tables whose rowsize exceeds the blocksize will have chained rows.
- Tables with long and long raw columns are prone to having chained rows.
- Table with more then 255 columns will have chained rows as Oracle break wide tables up into pieces.
Best regards.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
