Formatted/Unformatted Oracle Block....
Date: Sun, 30 Nov 2008 01:49:27 -0800 (PST)
When a block comes under the HWM,I believe its formatted by Oracle.What I want to know is that is there any bit in block dump which does differentiate that the block is unformatted or formatted? Secondly, is there a difference in the performance for oracle when it formats a totally clean block(block which is above the HWM) or it reinserts in the same block which is already formatted due to some earlier DML operation?
Operating System: Win Xp proffessional
Aman.... Received on Sun Nov 30 2008 - 03:49:27 CST