Obiee Usage Tracking Question — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Obiee Usage Tracking Question

Received Response
12
Views
4
Comments
dilek
dilek Rank 6 - Analytics Lead

Hi,

I want to see some obiee analysis & dashboards run time performance. So, I go to usage tracking tables 'S_NQ_ACCT' and look at the duration time which is 'total_time_sec' and say xxx seconds. But, in deep it is not correct. Because total_time_sec changes according to analysis run conditions. For example, for 1 day it goes 1 second, for 1 month it goes 5 seconds etc. Is there any way to find which conditions are used for running the queries? Not only for a few queries but many in my case. So looking query_text is not efficient.

Thank you for your interest.

Regards.

Answers

  • dilek
    dilek Rank 6 - Analytics Lead

    Hi,

    Is there any opinion for my question? If you help me, I will be glad.

    Regards.

  • [Deleted User]
    [Deleted User] Rank 5 - Community Champion

    UT just tracks the fact that things were run and how long they took. If you need more detailed analysis you will have to look further than UT.

    General system usage / performance / capacity logging of your Middleware, your DB, the server OS level, etc. etc.

    Performance is way too complex a topic to find an answer in one single place which only checks "was it run?".

  • dilek
    dilek Rank 6 - Analytics Lead

    Hi @Christian Berg-Oracle ,

    Thank you for your response. I understands that UT is not a performance management tool. I suppose that if I look at the report run parameters, I could compare the time elapsed between two different systems. May be from an sql query, I could take the parameters I need.

    Regards,

    Dilek

  • [Deleted User]
    [Deleted User] Rank 5 - Community Champion

    It will be better than nothing, but as I said it is extremely dependent on the surroundings. DB workload, network et al play a huge role.

    Most likely you don't have access to all information you'd need yourself. Most times you needs DBA at least to give input on the detailed DB side.