-
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....
-
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.
-
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?
-
Create it and let us know.
I remember when this place was cool.
-
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...
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
|