If I have a 40GB hard disk and 512MB RAM, and if I install Oracle 9i software on my PC, and if I start inserting records (with five columns), how many records can I enter? I mean, is there any limit for it, or does it depend on the hard disk space? Please tell me more about storage sizes of databases.

    Requires Free Membership to View

How much space data takes depends on a number of factors. Character data takes 1, 2, or 3 bytes for each character, depending on your characterset. I rarely use multi-byte charactersets so most of my character data is 1 byte per character. Number datatypes use between 2 and 9 bytes depending on the value being stored. Date datatypes require 7 bytes. Each row requires a little bit of overhead, but the big factor is the actual data being stored.

One also has to keep in mind that there is overhead just to run the database. The Data Dictionary (in the SYSTEM tablespace) will require at least 100MB. Plus, you have your TEMP tablespace, and your UNDO tablespace. Indexes will take space too.

With 40GB, you have enough room for a small database, but you might want to get a second hard drive for your system should this be too little. Oracle is only constrained by your disk space for storing records. Technically, you can store many, many petabytes of data in an Oracle database, but that much disk space will cost a fortune.

This was first published in May 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: