Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Dashboard drop down is taking more than 2 mins to load
Hi All,
Currently we are using OBIEE 11.1.1.7.140715
Once we logon to analytics link using SSO and click on "Dashboards" drop down, its taking more time to load. Can anyone suggest what could be the cause and best solution for that?
Sometimes its very fast. Not sure of cause for this inconsistent behaviour
Thanks in advance.
Raja
Answers
-
3269969 wrote:Sometimes its very fast. Not sure of cause for this inconsistent behaviour
That doesn't sound like you did a lot of investigation in to "What actually causes this?".
So with regards to your question "Can anyone suggest what could be the cause and best solution for that?":
1.) The cause can be pretty much anything. Most likely people will throw random things at you in this thread which you will the randomly try out without reflection on why this could be the solution for a problem you have not researched.
2.) The best solution is always: "It depends."
Seriously: Have you looked at any log files like the nqqery.log? If yes, which ones and what do the log files say? It can be (CAN be - I'm not saying it IS that!) that you're simply hitting a total performance bottleneck while thr prompt fires off its query in the background.
What kind of analysis and investigation have you done so far in general (apart from the obvious log files above)? WHERE are you losing performance because of WHAT?
In all honesty it is impossible to solve issues like this by just asking a question and then - again - randomly starting to push buttons and turn knobs.
As we keep saying in here and Robin has so nicely pointed out: Evidence based design and diagnostics!
0 -
@3269969 Did you abandon this question? Is it still open?
0 -
Hi There,
Yes, i did not do much investigation to identify the exact root cause.
We have access to dev servers and we didnt face similar issue in dev. This is identified in production and we are requested to find the cause for it. Unfortunately i do not have access to the production server and not sure of where to check on it.
I posted this query to see if anyone else in the Oracle community had similar issue and did anything to resolve it.
Because for these inconsistent issues, Oracle suggested to post in community where we get answers to most of the unanswered questions.
Please let me know in case if we are not allowed to post without actually knowing the root case. And if i had known how to debug it, i would have not posted the query itself.
Thanks
Raja
0 -
You can view most of the logs in Enterprise Manager in the log viewer if you can access it. The reality is you're not going to be able to do much without the access.. hopefully you can get into EM.
0 -
3269969 wrote:I posted this query to see if anyone else in the Oracle community had similar issue and did anything to resolve it.
In IT problems are a dime a dozen and performance issues are a cent a thousand :-) Plus: There are literally hundreds of potential factors influencing this.
You are allowed to post anyhting. But without any context or explanation as you delivered them in this last update our responses will potentially be as useless as the initial post in terms of a qualified question ;-)
Jokes aside: How does anybody expect you to solve an issue without access? Ask you management / client / whoever whether they also want to get invasive surgery without having been examined before. Just a thought...
0