1 Yes it can. Due to the LONG rows can get chained into multiple
Oracle blocks.
This will mean a *HUGE* performance hit.
Also the size of your record can exceed the Session Data Unit of
Sqlnet, resulting in multiple roundtrips.
Chaining will however have much more impact than SDU
2 set the SDU in your listener.ora and tnsnames.ora as per the Net 2.3
administrators manual. Note: SDU needs to be a multiple of the MTU of
your network card, usually 1500. By default SDU is 2048.
3 run
analyze table <foo> list chained rows into <chained_rows> table, and
reorganize your table.
--
Sybrand Bakker
Senior Oracle DBA
Received on Wed Aug 24 2005 - 06:08:31 CDT
