I have this litte doubt bout PCTUSED that needs to be cleared.
suppose i have a table with pctused as 60% and pctfree as 40%...
Noe the averrage row length of the table is such that it can hold 1 record with this 60%.
Now suppose i give the value for the first row such that only 45% of the space is occupied and 15% still remains free.
Now i insert another record that mite occupy say more than the available 15% in the block.So would it write the first 15% in this block and the remaining in the next block?
Woud row chaining take place in this case?