Re: Formatted/Unformatted Oracle Block....

From: hpuxrac <>
Date: Sun, 30 Nov 2008 06:21:33 -0800 (PST)
Message-ID: <>

On Nov 30, 4:49 am, Aman Sharma <> wrote:
> 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:-
> Operating System: Win Xp proffessional
> Thanks
> Aman....

For #1 have you tried dumping blocks and examining them?

For #2 have you tried creating some test cases and scripts where you can get results? Received on Sun Nov 30 2008 - 08:21:33 CST

Original text of this message