Aha, you're right. I do indeed notice a value,
nrow=87.
Thank you
mkb
- K Gopalakrishnan <kaygopal_at_yahoo.com> wrote:
>
> Hi,
>
> You don't need to do arithmetic to find number of
> rows in a block from block dumps. There will be a
> component in block dump called 'numrow' or 'nrow'
> which will tell how many rows are there in that
> block.
>
> It will be something like that in case if you have
> 20 rows
>
> nrow=20
>
> Best Regards,
> K Gopalakrishnan
> Bangalore, INDIA
>
>
> -----Original Message-----
> bhatti
> Sent: Tuesday, September 25, 2001 11:41 AM
> To: Multiple recipients of list ORACLE-L
>
>
> OK, so somebody asks me if there is a way to
> determine
> how full an Oracle data block is. I've been playing
> around with dbms_space and dbms_rowid packages but
> apparently, I can't see how these would help. A
> couple interesting scripts both on ixora and
> Jonathan
> Lewis web site seem to have helped. I used JL's
> script 'alter system dump datafile <df_no> block min
> <min_blk> block max <max_blk>;' to dump the segment
> header and block headers for various data blocks.
>
> For example, if I run this:
>
> alter system dump datafile 122 block min 4 block max
> 4, I dump the header info for block 4 in datafile
> 122.
>
> Question is, when I look in the trace file I see the
> following line:
> block_row_dump
> tab 0, row 53, @0x46c
> tl: 2 fb: --HDFL-- lb:0x1
> ...
> ...
> tab 0, row 98, @0x1f21
> tl: 2 fb: --HDFL-- lb: 0x1
> end_of_block_dump
>
> So, am I correct in assuming that there are 46 rows
> (98-53+1=46) in this block? If this is the case, I
> would be able to calculate the average row size for
> this block and do all sorts of silly little
> 'rithmetic
> calculations based on pctfree etc. This would give
> fairly granular insight into how tightly packed
> blocks
> are, right?
>
> Any opinions?
>
> tia
>
> mkb
>
>
> __________________________________________________
> Do You Yahoo!?
> Get email alerts & NEW webcam video instant
> messaging with Yahoo! Messenger.
> http://im.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: mohammed bhatti
> INET: mkb125_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
>
>
> Do You Yahoo!?
> Get your free @yahoo.com address at
> http://mail.yahoo.com
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: K Gopalakrishnan
> INET: kaygopal_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger.
http://im.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mohammed bhatti
INET: mkb125_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Sep 25 2001 - 15:37:29 CDT
