Home » Infrastructure » Windows » chaind rows
chaind rows [message #101445] Sat, 02 October 2004 06:19 Go to next message
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 Go to previous messageGo to next message
Frank Naude
Messages: 4579
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 #101672 is a reply to message #101445] Tue, 15 February 2005 17:18 Go to previous messageGo to next message
chaind
Messages: 1
Registered: February 2005
Junior Member
I don't know what chaind rows are, I'm just replying because "Chaind" is my name.
Re: chaind rows [message #101677 is a reply to message #101672] Fri, 18 February 2005 07:17 Go to previous message
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.
Previous Topic: installation problem of oracle 8i.1.7 on p4 1.7 (URGENT)
Next Topic: CONNECTIVITY PROBLEM OF ORACLE 8i 8.1.6 AND DEVELOPER 6i Forms Version 6.0.5.0.2 ON PENTIUM 4
Goto Forum:
  


Current Time: Thu Mar 28 13:41:36 CDT 2024