RE: Varied block density for fixed length row tables

From: "Rich Jesse" <rjoralist2@xxxxxxxxxxxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Wed, 14 Sep 2011 13:58:44 -0500 (CDT)

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

References:

Varied block density for fixed length row tables
From: Rich Jesse

Re: Varied block density for fixed length row tables
From: David Fitzjarrell

Re: Varied block density for fixed length row tables
From: Rich Jesse

RE: Varied block density for fixed length row tables
From: Bobak, Mark

RE: Varied block density for fixed length row tables

Other related posts: