ITCM MDB-SIZE ON ORACLE

book

Article ID: 18263

calendar_today

Updated On:

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.

Attachments