DX Infrastructure Manager

Expand all | Collapse all

!! UIM / OC 20.3.2 - problems after DB upgrade to Oracle 19 !!

  • 1.  !! UIM / OC 20.3.2 - problems after DB upgrade to Oracle 19 !!

    Posted 03-04-2021 04:01 AM
    Just posting our recent experience with UIM:

    Last week we have upgraded our UIM 20.3.2 database from Oracle 12 to Oracle 19 and the user experience totally worsened. SQL queries originating from CABI responsible for fetching data (QOS metrics) in Operator Console became unresponsive to the extent that the metrics graphs in OC are no longer displayed and the overall experience is, performance-wise, very poor.

    We are still investigating this with Broadcom support but if somebody else also experienced this, what was the solution?


  • 2.  RE: !! UIM / OC 20.3.2 - problems after DB upgrade to Oracle 19 !!

    Posted 03-04-2021 07:02 AM
    No but from a suggestion on where to point fingers:

    You had a working system and changed Oracle - There is little in UIM that is database server version specific and so in theory, if it worked well on v12 and not on v19 then the issue is most likely in the new Oracle install. Ask Oracle why it's slow.

    CABI is actually Jaspersoft from TIBCO. Broadcom just repackages it. You could ask TIBCO if there are known issues with Oracle 19.




  • 3.  RE: !! UIM / OC 20.3.2 - problems after DB upgrade to Oracle 19 !!

    Posted 03-04-2021 07:29 AM
    Actually, I forgot to mention that some performance issues with Operator Console were also present on Oracle 12, but not in such extent - we were assured by Broadcom guys that 20.3.3 should perhaps solve these. But DB upgrade made it worse.

    Regarding your CABI note, I am not entirely sure that "Broadcom just repackages it", as the affected SQL queries are dealing with s_qos_data + RN_|HN_|DN_ dynamic tables to get QOS metrics over selected time period, and these tables afaik have nothing to do with TIBCO, i.e. they're the UIM core tables.


  • 4.  RE: !! UIM / OC 20.3.2 - problems after DB upgrade to Oracle 19 !!

    Broadcom Employee
    Posted 03-04-2021 08:52 AM
    An increase in users will effect performance, and testing with only a couple users may help to narrow down the problem.
    Also what might help to track it down is to setup a test with only one person using OC and have the DBA checking for long running queries. Even with only one user there is a lot of action due to all the background tasks running.

    ------------------------------
    Support Engineer
    Broadcom
    ------------------------------