size of table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: size of table

  1. #1
    Join Date
    Dec 2002
    Posts
    32

    size of table

    what are the wasys to find the size of table
    thanks
    Sajeev

  2. #2
    Join Date
    Mar 2002
    Posts
    200
    Estimating the size of a table
    -----------------------------

    ANALYZE table COMPUTE / ESTIMATE statistics

    Get the AVG_ROW_LEN from DBA_TABLES, ALL_TABLES

    Table size = AVG_ROW_LEN * Number of Rows * (1 + PCTFREE/100) * 1.15
  3. #3
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    1. analyze table tablename compute statitics

    2. select blocks,empty_blocks from dba_tables where table_name='tablename';

    3. So the size of the table is (blocks+empty_blocks)*db_block_size

    4. You can find the db_block size by
    select value from v$parameter where name='db_block_size'
    Agasimani
    OCP(10g/9i/8i/8)

  4. 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