RE: Varied block density for fixed length row tables

From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Wed, 14 Sep 2011 13:58:44 -0500 (CDT)
Message-ID: <8214cc25327c25f7dc216356df53596e.squirrel_at_society.servebeer.com>



Mark replied:

> Then use:
>
> select dbms_rowid.relative_fno(rowid), dbms_rowid.rowid_block_number(rowid),
> count(*)
> from <table_name>
> group by dbms_rowid.relative_fno(rowid),
> dbms_rowid.rowid_block_number(rowid)
> order by 1,2;
>

Which perfectly validates that my original SQL works (and is at least twice as fast as the above), TYVM. :) Thanks, Mark!

So, my original question: why the different block densities from a single data load on what should be static row lengths?

Rich

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 14 2011 - 13:58:44 CDT

Original text of this message