-
to find actual size of a table:
select count (distinct substr(rowid,1,15)) from schema.table_name
explanation:
each rowid references a block. Sum of all the distinct blocks give you the actual table size.
HTH
-
so hows is a COUNT = to a SUM
you query wil return the number of rows
-
Originally Posted by newbie
to find actual size of a table:
select count (distinct substr(rowid,1,15)) from schema.table_name
explanation:
each rowid references a block. Sum of all the distinct blocks give you the actual table size.
HTH
Migrated and chained rows?
-
Originally Posted by slimdave
Migrated and chained rows?
The method I presented is the table size in Oracle blocks -- that would exclude all empty blocks below the HWM. IMHO, I would consider any block that contains the pointer or the actual migrated/chained rows as non-empty data blocks.
Originally Posted by davey23uk
so hows is a COUNT = to a SUM
you query wil return the number of rows?
Sorry for my poor usage. SUM in this context is the result of the query presented not the function SUM in oracle.
Last edited by newbie; 11-17-2006 at 10:10 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|