How To Determine Data Size Of A Table - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: How To Determine Data Size Of A Table

  1. #11
    Join Date
    Mar 2001
    Posts
    149
    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

  2. #12
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    so hows is a COUNT = to a SUM

    you query wil return the number of rows

  3. #13
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Quote 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?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #14
    Join Date
    Mar 2001
    Posts
    149
    Quote 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.

    Quote 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 09: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
  •  



Click Here to Expand Forum to Full Width