Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Table Fragmentation
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?
![]() |
![]() |