-
Hi,
I am in the process of creating 8i database. I would like to know how to estimate sizing information (storage parameters) for the tables. I have a test database where i have all the tables, but with very less number of records when compared to the actuals. I have the estimated number of rows which will be over a period of time too.
Anybody please tell me how to estimate the sizing?
It is URGENT.
Thanks in advance.
Regards.
Sundar
-
Analyze your test database schema.
You can get average rowlength of each table. Multiply this with your estimate of number of rows which will be inserted over a peiod of time. This will give you rawsize.
Now factor in additional space depending on your PCTFREE parameter and the kind of tablespaces you will use, DM or LMT's.
Hope this helps.
Nizar
-
Hi,
I have recently developed the excel sheet with the help of Oracle Press book for sizing the table.
Pl. send me your mail id so that I can send that one.
Thanks,
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
Dear Sam,
Thanks for the update.
My email id is kssundaralingam@hotmail.com
Thanks in advance.
Sundar
-
Me 2
Please send a copy to 2hm8zvl3001@sneakemail.com as well.
Thanks,
-Jason Martin
-
can i have a copy too? my email is hrluna@stsi.com.ph
thanks in advance....
-
I would also like to be shared with the xl matrix for the sizing info. I have been look to get one of this kind for a long time now. Thanks to ssundar and Jason martin. Please mail it to
eclipse_black1998@yahoo.com
-
send me a copy in
samahit2000@yahoo.co.in
Thanks
-
Instead of asking every one's mail id, why don't you put your mail id on the screen, because most of the people will be interested and who ever they want they will initiate and send a mail to you to which you can reply easily.
Thanks and don't mind.
Sanjay
san
-
copy of the Xls sizing doc
Hai Sam,
Can u please send a copy of your sizing doc.
Thanks in advance.
palanikumar_r@sakinfotech.co.in
Regards,
Palani Kumar. R
RP Kumar
You Can Win, if u believe Yourself
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
|