It's all about the answers!

Ask a question

Oracle DB initial size

Liora Milbaum (513282116) | asked Apr 29 '14, 10:16 a.m.

The initial recommended Oracle DB size is 1 GB. Is it really required or can we start with 200 Mb and increase the size when reaching the limit?


One answer

permanent link
Philippe Chevalier (56114) | answered Apr 29 '14, 10:55 a.m.
The question is a little vague,  a database default tablespace maybe 1 GB in size.   This does not include any redo log files and any other files required to support the Oracle instance on the file system.   Also, the default tablespace USER and TEMP are avoided since our doc suggest that each CLM user (schemas) own their default and temp tablespaces.

Looking at the scripts to create the CLM solution, the 1 GB initial size becomes irrelevant.   The Tool by default will required close to 5 GB of Disk space.

PLease review the following two links

More Control over the DB2 Data Warehouse Setup

The Total size for the DW becomes 1.2GB.

The recommended scripts for each of the product recommend to start the Tablespace size to 1 GB each.

Setting up an Oracle database 

Liora Milbaum commented Apr 29 '14, 11:38 p.m.

Thanks Philippe, you are right. The question was vague.

The issue is the we already have an oracle database used for other purposes. Adding at least 4 additional table spaces, 1GB in size each, is somewhat painful. The question was, is it really necessary to start with a 1GB size for each table space?

Donald Nong commented May 02 '14, 5:57 a.m.

Good planning will save you a lot of headache down the track. CLM data can grow very fast, so starting with a small tablespace size offers virtually no benefit.

Your answer

Register or to post your answer.