Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

How to tune Performance in OBIEE 11.1.17

Received Response
23
Views
23
Comments
2933551
2933551 Rank 3 - Community Apprentice
edited Aug 13, 2024 5:38PM in Oracle Analytics Cloud and Server

I have a dashboard which run within  almost 5min but its back sql run fast in Database side by 25s.

May I know why it is slower that db?

Besides, I found 2 time in Administration.  one is 27s another is 4m55s. the second one is actual dashboard run time.

How to tune the performance?

NEW TBS1.jpg

«13

Answers

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

    1.) Push the log level to 7

    2.) Get the detailed log

    3.) Check WHERE the time gets lost

    4.) Start investigating.

    There is no magical GO_FASTER=TRUE setting ;-)

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Also are you comparing like with like - is your faster DB sql running at the same time from the same client?

  • Joel
    Joel Rank 8 - Analytics Strategist

    Also, do you get the same performance issue when you run the SQL directly on the OBIEE server using SQL*Plus?

  • 2933551
    2933551 Rank 3 - Community Apprentice

    I already mentioned the query only run 12s on db no performace issue

  • 2933551
    2933551 Rank 3 - Community Apprentice

    Thanks Christiam,   could  you  share more detail ?

  • 2933551
    2933551 Rank 3 - Community Apprentice

    no performance in DB

  • Gianni Ceresa
    Gianni Ceresa Mod 
    2933551 wrote:I already mentioned the query only run 12s on db no performace issue

    What Joel was asking is if you run that query in the DB via SQL*Plus from the OBIEE server : it's different than just "the query run in only 12s on the DB" (there are "things" which can make a huge difference .... like .... a bad networking performance?)

  • Gianni Ceresa
    Gianni Ceresa Mod

    All in all you need to do a "response time profiling" : https://www.rittmanmead.com/blog/2013/03/performance-and-obiee-analysing-results/

    Only based on that you can identify what need to be tuned.

    Any other approach will be just random guessing, setting things, turning them on and off hoping it will change something (and you will maybe add other issues in your system by doing so).

  • Joel
    Joel Rank 8 - Analytics Strategist

    Thanks @Gianni Ceresa. You beat me to it again!

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

    Gianni posted one of the usual and obvious links.