Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> in line clob storage and chain rows

in line clob storage and chain rows

From: Ted Chyn <tedchyn_at_yahoo.com>
Date: 1 Apr 2002 20:52:36 -0800
Message-ID: <44a19320.0204012052.5ba704b9@posting.google.com>


all,

I have a table with inline clob storage.

1. most clobs are < 2k xml doc. 
2. The table defined with pctfree 30% and
3. No updates delete and insert only.

As result of delete and insert, chained rows grow rapidly and I rebuilt them every week.

My question:

  1. How does oracle manage storage for inline clob segment ?
  2. Does pctfree 30% also applies to inline clob segment ?
  3. What cause the growth of chain rows. In a regular table without clob delete and insert do not cause chain rows to be formed ?

thanks in advance
Ted Chyn Received on Mon Apr 01 2002 - 22:52:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US