I have an external table authentication implemented when a user is login to OBIEE its taking y 3-4 minutes of waiting for them to login. No performance issues after login.
Solution:
Check whether the initialization blocks are using the same connection pool that the queries are using. If so, best practice is to dictate that initialization blocks for authentication be given their own connection pool, otherwise you might have a situation where nobody can authenticate as they have been busy waiting along with all the other queries for a connection pool thread.
Create dedicated connection pools for your Session Variables.
Solution:
Check whether the initialization blocks are using the same connection pool that the queries are using. If so, best practice is to dictate that initialization blocks for authentication be given their own connection pool, otherwise you might have a situation where nobody can authenticate as they have been busy waiting along with all the other queries for a connection pool thread.
Create dedicated connection pools for your Session Variables.
No comments:
Post a Comment