Skip to Content
avatar image
Former Member

Diff between MCOD and NONMCOD

Hi folks,

can anyone of u help me out for selecting exiting database -Multiple component in one database (MCOD) or Non-MCOD type of database for my BW-3.5 installation

where i am using oracle-10.2.0.2.

plz tell me as per performance wise which would be suitable.

thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 04, 2007 at 05:57 PM

    MCOD is a pain in the neck. yes, it works, but you are also putting your eggs in the same basket.

    it is much better an easier to manage if you use one instance per database.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 06, 2007 at 01:05 AM

    Hi

    MCOD is recommended for non-production systems. Basically it is only one DB server but multiple instances/schemas.

    - You have to take backup for full DB server with all instances. There is not instance/schema backup as such.

    - If you have to recover, then recovering will be done to all instances, which means loss of data

    - Any maintenance to one server will effect all other servers

    Regards

    Madhu

    Add comment
    10|10000 characters needed characters exceeded