Clarity

 View Only
  • 1.  Datamart Extraction running slow in Oracle 12c (Clarity 14.3)

    Posted Oct 26, 2017 11:21 AM

    Datamart Extraction is running very slow into our Clarity 14.3 with Oracle 12c.

     

    Identified culprit is NBI_POPULATE_OBS_DIM_SP and most probably NBI_POPULATE_OBS_RECURSIVE_SP() which is called eventually.

     

    With regards to configuration is as per CA guidelines except Oracle 12c compatibility is set to 12.2 and not 11g.

     

    Open a case with CA but no luck. DBA couldn't help either.

     

    Has anyone faced this issue? Thanks in advance for help.



  • 2.  Re: Datamart Extraction running slow in Oracle 12c (Clarity 14.3)
    Best Answer

    Broadcom Employee
    Posted Oct 26, 2017 11:54 AM

    Hi Dharmesh,

     

    With Oracle 12 there was regression and there is workaround, not sure if you tried this. 

     

    Post-Upgrade: Optimize Oracle 12c Performance

    To optimize performance for environments using Oracle 12c R1 or R2, follow the steps below.

    1. If you have local installations of Oracle 12c R1 or R2, you might detect a regression issue with Oracle 12c when ORDERED hint is used in structured queries. As an option, we recommend applying the following fix locally. From a command prompt, enter this series of commands in Oracle:

       sqlplus / as sysdba
        ALTER SYSTEM SET "_fix_control" = '17800514:0';
      Exit;

     

    We have that documented in 15.3 change impact guide 

     

    Change Impact and Upgrade (On Premise) - CA PPM - 15.3 - CA Technologies Documentation 

     

    Regards

    Suman Pramanik 



  • 3.  Re: Datamart Extraction running slow in Oracle 12c (Clarity 14.3)

    Posted Oct 26, 2017 04:04 PM

    Thank you for your response. We changed this just now but, procedure (NBI_POPULATE_OBS_DIM_SP) is running for more 15+ mins so I'm assuming it has not made any changes.



  • 4.  Re: Datamart Extraction running slow in Oracle 12c (Clarity 14.3)

    Posted Oct 26, 2017 04:09 PM

    SumanPramanik

     

    DBA has question that: Is Clarity 14.3 certified  for 12C multitenant architecture? Do you have any insights on this?



  • 5.  Re: Datamart Extraction running slow in Oracle 12c (Clarity 14.3)

    Broadcom Employee
    Posted Oct 27, 2017 02:20 AM

    Hi Dharmesh,

     

    No we don't support database as multi tenant but we have plans to make that compatible soon.

     

    Regards

    Suman Pramanik 



  • 6.  Re: Datamart Extraction running slow in Oracle 12c (Clarity 14.3)

    Posted Nov 10, 2017 02:35 PM

    Hi Suman,

     

    Do you have any update or information on how soon Clarity 14.3 will be "officially certified" with Oracle 12c multi tenant? Apart from the datamart extraction job issue(which is now fixed), we are not experiencing any issues with v14.3 & Oracle 12c multi tenant in our development environments. 

     

    Thanks,

     

    Rodney



  • 7.  Re: Datamart Extraction running slow in Oracle 12c (Clarity 14.3)

    Broadcom Employee
    Posted Nov 13, 2017 02:30 AM

    Hi Rodney,

     

    We do support new stack/feature only in new upcoming release. I am sorry 14.3 will not be supported. However I had a discussion on this and we will soon officially support it. 

     

    Also can you please let us know the solution for Datamart Extraction Job so that it can help other community members.

     

    Regards

    Suman Pramanik