Dashboard drop down is taking more than 2 mins to load

Question

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

[Deleted User] · Answer

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

Daniel Willis · Answer

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.

User_AV9GR · Answer

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