DX Infrastructure Manager

Expand all | Collapse all

CA UIM: Use Oracle Data Base

Jump to Best Answer
  • 1.  CA UIM: Use Oracle Data Base

    Posted 06-05-2018 03:14 AM

    We are going to install CA UIM using Oracle DB 12c, and we want to know what characteristics we should take into account?
    Like PGA, SGA, Charset, Nchar, sessions, shared session, etc.



  • 2.  Re: CA UIM: Use Oracle Data Base



  • 3.  Re: CA UIM: Use Oracle Data Base

    Posted 06-05-2018 08:21 AM

    Hi Ryan,

    What happens is that the client needs this information to be able to create the database in his cluster. In the documentation it only shows the general command, without that specific information for CA UIM.



  • 4.  Re: CA UIM: Use Oracle Data Base
    Best Answer

    Posted 06-06-2018 09:26 PM

    Hi Martin,

     

    I have seen customers using Oracle as backend will eventually increase suggested values for parameters like processes, sessions and transactions.

     

    If eventually you will have a very large Oracle db, decide a proper parallel level on your tablespace and use an Enterprise version also a proper processes accordingly.

     

    For memory, use the the default automatic memory management.

     

    We support shared server architecture as mentioned in the doc, but have at least processes > shared_servers +100

     

    Choose proper charset when installing Oracle to avoid unnecessary conversion in the client side, pls consult your dba.



  • 5.  Re: CA UIM: Use Oracle Data Base

    Posted 06-08-2018 07:40 AM

    Hi Carlos,

     

    Please let us know if your question has been answered by marking a correct answer or let us know if you need more information.

     

    Thanks,

    Alex