Import & export caused more chained rows....

You have a LONGRAW column in your table. LONG and LONGRAW columns are st ored
in-line and can hold up to 2 gig worth of data. By increasing your pct f ree
you are effectively decreasing the amount up usable space in the block fo r
inserts. The higher you put this setting, the more the rows in this tabl e
will chain on import. If you don't plan on updating the table often or i f
your updates are not likely to increase the length of the row, set pct lo w.

Another thing you can do is increase your block size. Finally, depending  on
the amount of data you are putting into this column, chaining might be unavoidable. These columns can hold 2 gig and the maximum size of an Ora cle
block is 32K (I believe this number is OS dependent and could be flat out

wrong but you get the idea).                                                                     

Get free email and a permanent address at http://www.amexmail.com/?A

-- 
Posted from aw163.netaddress.usa.net [204.68.24.63] 
via Mailgate.ORG Server - http://www.Mailgate.ORG