| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Is the effect of modifying PCTFREE/PCTUSED immediate ?
Is the effect of modifying PCTFREE/PCTUSED immediate ?
If I do an "ALTER TABLE <tablename> PCTFREE 99 PCTUSED1", does this take effect immediately, even for existing blocks. [If so, existing blocks would not get new rows inserted]. Or is it effective only in new Extents ? In that case, existing blocks in existing Extents still use the old PCTFREE/PCTUSED parameters and keep re-entering the FreeList.
Hemant Received on Tue Sep 24 2002 - 09:21:29 CDT
 |
 |