Formatted/Unformatted Oracle Block....

From: Aman Sharma <amansharma1981_at_gmail.com>
Date: Sun, 30 Nov 2008 01:49:27 -0800 (PST)
Message-ID: <a725dbd2-1b73-4227-ae70-7ac631d2bc06@40g2000prx.googlegroups.com>


Hi,
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?
Database version:-10.2.0.1/11.1.0.6
Operating System: Win Xp proffessional
Thanks
Aman.... Received on Sun Nov 30 2008 - 03:49:27 CST

Original text of this message