calculating space for new table?
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
how i do calculate the sizing... any formula,pls tell me....
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
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...
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Create it and let us know.
I remember when this place was cool.
In 10g you have a new segment resource estimation feature:
Saves you having to work on homebrew methods.
Click Here to Expand Forum to Full Width