Obiee Usage Tracking Question

Question

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.

[Deleted User] · Answer

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.

dilek · Answer

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] · Answer

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?".