ITCM MDB-SIZE ON ORACLE

Products

• CA Client Automation
• CA Server Automation

Issue/Introduction

Customer wants to understand the significance of MDB size option appears while installing MDB on oracle database.

Environment: ITCM MDB fresh install on oracle database.

 

Environment

CA Server Automation, CA Client Automation - All versions

Resolution

MDB size refers to the initial table space sizes created during MDB installation. There are two table spaces created during MDB install, MDB_DATA and MDB_INDEX. Selection of table space size depends upon customer requirements and environment structure.

There are four options available to choose MDB_SIZE. Here are the details:

MDB_SIZE	MDB_DATA (size in MB)	MDB_INDEX (size in MB)
Small	400	100
Medium	600	200
Large	800	400
Huge	1000	600

 

Additional Information

1. By default, MDB_SIZE will be medium.
2. MDB_SIZE option is not valid for upgrade scenarios as table space will already
3. be present and same will be used.
4. Table spaces are created with AUTOEXTEND clause ON. Hence, during operations
5. depending upon need table spaces will be increased automatically.