2 Replies Latest reply: Jul 2, 2013 5:38 AM by 1010689 RSS

    MDS repository location

    1010689

      Hi,

      I'm using Jdev 11.1.2.3.0.

       

      We are planning to enable MDS for the application.

      My application connects to Oracle Apps tables. I want to know whether the MDS schema should be created in the same DB where oracle apps is running or create a separate db for MDS?

      Is there any best practice regarding the location of the MDS DB.

       

      Can you please suggest.

       

      Thanks,

      Vinod

        • 1. Re: MDS repository location
          Frank Nimphius-Oracle

          Hi,

           

          this certainly is the wrong forum to ask Apps specific questions. From a MDS repository perspective there is no reason why it cannot be in this database because MDS uses a different database schema. The rule for MDS is that the database that holds the artifacts should not be too far away from where the application runs. Personally I think that having a separate metadata database on a separate server makes sense from a performance perspective if the application database is under heavy load

           

          Frank

          • 2. Re: MDS repository location
            1010689

            Thanks Frank.

            Not sure whether it is correct forum, we are enabling MDS for ADF Application, thats why posted here.

             

            Thanks,

            Vinod