+ Reply to Thread
Results 1 to 3 of 3

Thread: size of table

  1. 01-27-2003 09:27 PM #1
    sajeev
    sajeev is offline Junior Member
    Join Date
    Dec 2002
    Posts
    32

    size of table

    what are the wasys to find the size of table
    thanks
    Sajeev
    Reply With Quote Reply With Quote
  2. 01-27-2003 10:41 PM #2
    quester's Avatar
    quester
    quester is offline Member
    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
    Reply With Quote Reply With Quote
  3. 01-27-2003 10:46 PM #3
    agasimani
    agasimani is offline Senior Member
    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)
    Reply With Quote Reply With Quote
    4. « Previous Thread | Next Thread »

    Bookmarks

    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