Re: PCT_FREE/PCT_USED [message #50437] |
Thu, 14 March 2002 18:01 |
kiran srirama
Messages: 14 Registered: March 2002
|
Junior Member |
|
|
Hi Ron !
Yes , you can create a table with PCT FREE 0. ORACLE does not report any error in doing so. You could set this to 0 in your table. But doing so may cause problems if you might update your table.
ROW CHAINING is not much related to PCT FREE.
Instead, its more of a block size / row size related issue. You could reduce ROW CHAINING by either increasing the block size of your database.
PCT FREE comes into actual picture when ROW MIGRATION is considered.
Once again, to summarize, ROW MIGRATION is mainly caused due to lower values for PCT FREE.
ROW CHAINING is mainly caused due to smaller block sizes and the ROW SIZE of your table.
Hope this clarifies you.
Could get back to me if any doubt.
Regards
Kiran Srirama
|
|
|