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

Home -> Community -> Usenet -> c.d.o.misc -> Table Fragmentation

Table Fragmentation

From: pauldb <luapdb_at_yahoo.com>
Date: Thu, 01 Jul 1999 02:39:31 -0800
Message-ID: <930825573.22636@www.remarq.com>


I have a table where there is always a large percentage of updating on the table. And the change of row size is from approx 50bytes to 2000 bytes.

So I need to check that the values PCTFREE and PCTUSED are optimal.

The question is:

1) how can I check if there are chained blocks?
2) Is there a way to check if these values are optimal?
3)any suggestions for an optimal setting?



Received on Thu Jul 01 1999 - 05:39:31 CDT

Original text of this message

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