DX Unified Infrastructure Management

 View Only
  • 1.  CA UIM: Use Oracle Data Base

    Posted Jun 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 Jun 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

    Broadcom Employee
    Posted Jun 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

    Broadcom Employee
    Posted Jun 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.