Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

Continuing with my school-project, now I have to estimate the size of the database from here to 5 years. They give me a formula, so, in that formula, one of the values is the size of the empty database (when it is created, and doesn't have any tables, index, etc.).

For example, for MySQL, I found here that it is 10 MB.

But, for Oracle, what is the size?

I don't have Oracle or any RDBMS to make queries, it is just a work of research. I've googled a little, but I haven't found for Oracle.

Any version of Oracle (9 or later) is okay.

share|improve this question
1  
"I don't have Oracle or any RDBMS to make queries" why not? How will you test any answer given here if you have no database to run it on? Here are some Pre-Built Developer VMs (for Oracle VM VirtualBox) including developer and express editions. – Jack Douglas♦ Aug 27 '12 at 9:04
because it's a researching homework. It's an aproximation - it's not real. It's to understand the concept of estimation on a project. They give us a project, and we have to make a design and choose a RDBMS, and present the documentation (as a licitation). We had choose Oracle (for the size of the project) but we don't have Oracle to test the design in querys, about the space – ElVieejo Aug 27 '12 at 13:46
Well I highly recommend testing anything you propose whether it is theoretical or not because a) you are much less likely to submit something wrong, and b) you will learn a good deal more in the process - isn't that the real purpose of homework, to learn? – Jack Douglas♦ Aug 27 '12 at 13:56
I guess you're right - The project is to emulate the instance since the idea of a project, to the presentation in a licitation. It's only documentation, I don't know if in the reality the design of paper is really created and checked and tested - that won't happen when the project is accepted ? – ElVieejo Aug 28 '12 at 0:03

1 Answer

up vote 8 down vote accepted

First, are you using "database" in the Oracle sense of the term? Or are you using it in the sense that other database vendors (such as SQL Server or MySQL) use the term?

If you are using "database" in the Oracle sense, that would be the size of the SYSTEM and SYSAUX tablespaces at a minimum and would possibly include the size of the UNDO and TEMP tablespaces. On a small laptop system, that's probably on the order of 2 - 3 GB but it could be much bigger.

If you are using "database" in the sense that other database vendors use it, that's what Oracle calls a schema. An empty schema (a schema with no objects), by definition, consumes 0 bytes of storage. That's because space is allocated to tablespaces which are independent of schemas-- a single schema can have objects in many different tablespaces, a single tablespace can have objects owned by many different schemas, and a single object (if you're using partitioning) can be spread across multiple tablespaces.

share|improve this answer
amm, you got me here ! I had never used Oracle - so I'm not sure about the answer. I guess it will be in the Oracle sense. I think I will have to ask about that. Anyway, you give both answers - Thanks ! – ElVieejo Aug 26 '12 at 20:36

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.