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:
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-lReceived on Wed Sep 14 2011 - 13:58:44 CDT