Re: Datablock Dumps again

From: Madhavan Amruthur <mad012000_at_hotmail.com>
Date: Fri, 08 Dec 2000 07:24:44 -0800
Message-Id: <10704.124023@fatcity.com>

Hi Gopal,
I maybe wrong here but I think avsp is the average space in the databblock and tosp is the total space in the data block.

The average space could be over a period of time as the block has rows remove and added and total space is at the instance the block is being dunmped.

I am sure people will correct me if I am wrong. Regards,
Madhavan

>From: "K Gopalakrishnan" <kaygopal_at_yahoo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Datablock Dumps again
>Date: Fri, 08 Dec 2000 04:00:31 -0800
>
>
>In Block dumps the free space available
>in the block is visible in two places.
>avsp=0x333
>tosp=0x333
>
>And in most cases both are same.
>But in some cases the spaec differnce
>between avsp and tosp is differing
>0x100 - 0x200 .
>
>Can anyone tell me the difference between
>avsp and tosp??
>
>Best Regards,
>K Gopalakrishnan,
>
>
>
>
>
>
>
>
>
>
>
>
>

---

Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com Received on Fri Dec 08 2000 - 09:24:44 CST