Our OBIEE portal was not logging in for quite some time. When we entered the user Id and password, the screen would show up as if it is going to log in but it doesnt. our infrastrcture guy blames it on the following query. He says that its the long running query that is not allowing us to login. When logged in this report comes back really quickly but I am not sure how to tackle him. Is it possible that, this query is the problem ? It does not hold the database resources too. we have checked that. I believe he talking about the stale cache. I am not sure how to justify. Please help. please help with understanding the following log. He has highlighted the milliseconds. Iam not sure if thats the cause.