It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,628
×4,647

question asked: Apr 29 '14, 10:16 a.m.
question was seen: 4,127 times
last updated: May 02 '14, 5:57 a.m.

Related questions

FAQ - How this Forum works

Oracle DB initial size

0
Liora Milbaum (513●2●82●115) | asked Apr 29 '14, 10:16 a.m.
 Hi,

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?

Thanks,
Liora

One answer

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Philippe Chevalier (56●1●1●4) | answered Apr 29 '14, 10:55 a.m.
JAZZ DEVELOPER
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
https://jazz.net/wiki/bin/view/Main/MoreControlOverTheOracleDataWarehouseSetup

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
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m6/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_oracle.html 
Comments
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.