Tablespace Calculation

[joe_cqr]

Hello everyone, you know how do I calculate the required size for my tablespace, or do you know where I can find on the net ??

Valeu

Alex

[gilbertoca]

Who determines the size of a tablespace is you!
Of course this task needs an information base, for example: the number of objects, the mean of the object size, if these objects tends to growth in long or short-term, if a pre-existing for import, etc.

Gilberto

[joe_cqr]

So and from this pass I need, I know how many records and how long my table will be loaded, so I need to calculate the size required for the table, it follows that there are some formulas to make this calculation, someone knows how to tell me where I ???

grateful !!!

[pzuchelli]

Friend,

to estimate the space required by a table, you need to know 4 values:


-> Oracle's block size ;
-> The PCTFree value of the table;
-> The mean length of a line;
-> The number of lines expected for the table.

Ex:

Block size = 4KB
Available space = 4006
Percentage available = 98%

4006 bytes - (0.1 * 4006 bytes) = 3605.4 bytes, rounding down = 605.


I hope I could have helped you.