Q

How many records can I enter?

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.

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.

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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close