calculating space for new table?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: calculating space for new table?

  1. #1
    Join Date
    Mar 2005
    Posts
    26

    calculating space for new table?

    Hi friends,
    rightnow i am in tablespace sizing of new project, can anybody tell,by looking from below table structure, for 1 million records, how much its occupies the space in tablespace..

    CREATE TABLE ASC_OT_TPL
    (
    SDC_INST_N NUMBER(10)
    ENTIY_TY CHAR(5),
    TBL_NM VARCHAR2(20),
    ANA_TIMESTAMP DATE
    )
    and db_block_size=8k
    how i do calculate the sizing... any formula,pls tell me....

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,015
    It will be between 45 and 50 megs. Add up the size of the columns, then multiply by the number of rows, and round up. Date fields are 7 bytes.
    this space intentionally left blank

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Not enough information for any kind of estimation. You don't say what range of numbers will be stored in in NUMBER(10) column, what will be be the avarage length of the VARCHAR2(20) strings, you don't say how much NULL values will be stored in any of those table columns, etc etc.
    So each row could occupy somewhere between 1 byte and slightly less than 40 bytes of space. Plus the block header overhead, plus PCTFREE, etc, etc...
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    Create it and let us know.
    I remember when this place was cool.

  5. #5
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Hi.

    In 10g you have a new segment resource estimation feature:

    http://www.oracle-base.com/articles/...rce_estimation

    Saves you having to work on homebrew methods.

    Cheers

    Tim...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

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