Re: Formatted/Unformatted Oracle Block....
Date: Sun, 30 Nov 2008 06:21:33 -0800 (PST)
Message-ID: <0c648cd8-c21b-4c36-ab44-ebe4137c7e42@g38g2000yqn.googlegroups.com>
On Nov 30, 4:49 am, Aman Sharma <amansharma1..._at_gmail.com> 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:-10.2.0.1/11.1.0.6
> 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