Suggestion for new Oracle Server
Can anybody suggest me good architecture required for the
database server which we are going to buy for
our new application going to run on ORacle..
Details :
Database : 1gb growing 10% a month.
Front end : Vb
No of Users :50
Please tell me the technical details required to
improve the performance as well as
cost saving.
Thanks
Giri
Re: Suggestion for new Oracle Server
Quote:
Originally posted by engiri
Can anybody suggest me good architecture required for the
database server which we are going to buy for
our new application going to run on ORacle..
Details :
Database : 1gb growing 10% a month.
Front end : Vb
No of Users :50
1GB initial + 10% per month (100MB per month) = 1GB + 100MB*12months = 1GB + 1.2GBper year =2.2GB per year.
For 10 Years 2.2GB*10=10.2GB.
Total Hard Disk=10Gb for data + 3GB for Oracle software + 5GB for OS + 20 extra for backup=40GB Approx.
No of users 50.
Lets assume 1 user uses 10M of memory. so 50users*10MB=500MB RAM
TOTAL Ram: 500MB + 1GB for oracle + 500MB for OS = 2GB RAM.
Application VB. No idea.
Quote:
Originally posted by engiri
Please tell me the technical details required to
improve the performance as well as
cost saving.
Thanks
Giri
If the details given above are not technical enough then read the Tuning Manuals.
HTH
Re: Re: Suggestion for new Oracle Server
Quote:
Originally posted by adewri
1GB initial + 10% per month (100MB per month) = 1GB + 100MB*12months = 1GB + 1.2GBper year =2.2GB per year.
For 10 Years 2.2GB*10=10.2GB.
HTH
Slight Calculation Error, 2.2*10=22. ;)
However, 1GB with 10% growth per month, for 10 years would yeild
(1 + 102.4*12*10) = 13GB
;)
Re: Re: Re: Suggestion for new Oracle Server
Quote:
Originally posted by abhaysk
Slight Calculation Error, 2.2*10=22. ;)
However, 1GB with 10% growth per month, for 10 years would yeild
(1 + 102.4*12*10) = 13GB
;)
Yep, right was never good in Maths :), i think i added up 1 GB extra per year :)