EXPERT RESPONSE
Your answer isn't an easy one to give. First of all,
you'll need storage space to install the Oracle 9i
RDBMS software. According to the Oracle documentation,
the software installation for the full Enterprise
Edition is a little less than 3 GB. But, you can
scale this back some if you don't install all the
options, only those that you need.
Secondly, the hard part comes into determining how
much space is required to store your data. The SYSTEM
tablespace will take approximately 200 MB. But
sizing your TEMP tablespace, your UNDO tablespace,
your online redo logs and your archive log
destination can only be determined if you have all the
details on system usage. This doesn't take into
account the actual tables and indexes (and other
segments) that you create for the database. You
haven't given enough information for anyone to make an
accurate estimate.
The best place to start is to look at your current
space usage. Determine which tables will need to grow
to handle your growing user and customer base. By
looking at these tables, you can get an idea of how
much more space is needed if you double, or triple the
space requirements.
Oracle Enterprise Manager does have a component called
Capacity Planner. This may help you in the future.
For More Information
|
