Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 12c Analytics Login performance issue

Received Response
613
Views
15
Comments
2»

Answers

  • Jagadish Cherukuri
    Jagadish Cherukuri Rank 1 - Community Starter

    1. First time, when OBIEE starts, First session takes time to load. This is usual behavior...

    2. If more  than one connection pools fails.. OBIEE automatically disables the connection pools and takes time to load. Better change all the passwords of connection pools & try it.

  • vgarg
    vgarg Rank 1 - Community Starter

    Try enabling the parameter - "Allow Deferred Execution" parameter for the initialization blocks.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    This thread is a perfect example of how not to tackle performance issues. Not providing detailed information, not doing research and root cause analyses as well as random "solutions" posted without any context - basically throwing stuff at the problem and maybe something will stick.

  • Adam Wickes
    Adam Wickes Rank 6 - Analytics Lead

    To be fair Christian, we had login time issues which were caused by using Oracle service connections in our connection pools. We discovered this by disabling our init blocks which confirmed they were the issue. I thought that would be relevant in this case but it seems the OP ignored my suggestion so we'll never know.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    Adam Wickes wrote:We discovered this by disabling our init blocks which confirmed they were the issue.

    That means you did testing and research into the issue probably prompted by the init block execution times in the logs. So that is valid.