Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Obiee Usage Tracking 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.
Answers
-
Hi,
Is there any opinion for my question? If you help me, I will be glad.
Regards.
0 -
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?".
0 -
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
0 -
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.
0