Home > Ask the Oracle Database / Applications Experts > Questions & Answers > Storage space required for 9i
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

Storage space required for 9i

Brian Peasland EXPERT RESPONSE FROM: Brian Peasland

Pose a Question
Other Oracle Categories
Meet all Oracle Experts
Become an Expert for this site
>
QUESTION POSED ON: 19 March 2003
Can you inform me how much storage space will be required for an Oracle9i database? The database is for an IT technical consulting company upgrading their system to Oracle9i, with its workforce expanding from 100 employees to 450 employees, and its client base to triple by 2005. Also I must take into account the current space used and extra data stored on the server. I really need your help, my job depends on it!

>

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


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Oracle White Papers: Fusion Middleware
HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts